How to Copy and Paste Email Into Excel With VBS
Microsoft Excel is the spreadsheet program included in the Microsoft Office Suite. Visual Basic Scripts (VBS) is the programming language used for programming macros in Excel. Macros are small programs that automate processes in hopes of saving time. If you would like to eliminate the tedium from copying excel data into outlook, use Visual Basic Scripts to automate the procedure. Code has already been written to accomplish this task so the process requires no more than a download and integration.
Other People Are Reading
Instructions
-
-
1
Download the code (see Resources).
-
2
Extract the code file. Right click the zip file icon and select "Extract here."
-
-
3
Copy the file "Message.xls" to the Excel templates folder. Right click the file "Messages.xls" from the folder that was created when the zip file was extracted. Select "Copy." Navigate to the following folder: "C:\Windows\Application Data\Microsoft\Excel\XLStart" then paste the file by clicking "Edit," "Paste."
-
4
Return to the folder where the zip was extracted.
-
5
Copy the visual basic script to any folder. Right click the file "MailMessagesToExcel.bas" and select "Copy." Navigate to any folder and click "Edit," "Paste."
-
6
Launch Microsoft outlook by clicking "Start," "Outlook."
-
7
Select the necessary references. Click "Tools," "References." Make sure that there are check marks in the boxes for: "Microsoft Excel," "Microsoft Word," and "Scripting Runtime." Click "OK" when finished.
-
8
Import the module. Click "File," "Import." Navigate to the file "MailMessagesToExcel.bas" and open it.
-
9
Run the module. Click "Tools," "Modules." A dialog box will appear. Click "MailMessagesToExcel," then press "F5."
-
10
Select the mail folder. The script will launch a dialog box that will display your message folders. Select the folder that you would like to export to an Excel worksheet then click "OK."
-
11
Save the Excel worksheet. A save dialog will appear on the screen. Navigate to a folder where you would like to save the Excel worksheet of the mail messages. Give it a name and click "Save."
-
1
