Word 2010: Mail Merge to Email with Attachments
Word 2010: Mail Merge to Email with Attachments
Table of Contents
TO SEE THE SECTION FOR MACROS, YOU MUST TURN ON THE DEVELOPER TAB:...............2 SET REFERENCE IN VISUAL BASIC: .........................................................................................................2 CREATE THE MACRO TO USE WITHIN THE MAIL MERGE:.............................................................2 CREATE THE DIRECTORY FOR THE MAIL MERGE USING OUTLOOK CONTACTS: ................4
CREATE THE EMAIL MAIL MERGE AND RUN THE MACRO: ...........................................................................5 CREATE ANOTHER EMAIL MERGE WITH ATTACHMENTS USING AN EXCEL FILE AS THE SOURCE: .............................................................................................................................................................6
CREATE THE MAIL MERGE AND RUN THE MACRO:........................................................................................8 ADD THE MACRO TO A BUTTON ON THE QUICK ACCESS TOOLBAR: .........................................8
Word 2010: Mail Merge to Email with Attachments ICT Training, Maxwell School of Syracuse University
This procedure is credited to Doug Robbins, Microsoft MVP
Page 1
To see the section for Macros, you must turn on the Developer tab: 1) File / Options / Customize Ribbon / check Developer under Customize the Ribbon / OK
Set reference in Visual Basic: 1) Developer tab / Code group / Visual Basic
2) In the Microsoft Visual Basic window, choose Tools / References
3) Scroll to "Microsoft Outlook ## Object Library" / check this option / OK
4) File / Close and Return to Microsoft Word
Create the macro to use within the Mail Merge:
1) Copy the code needed for the macro - to be pasted into the Visual Basic window: a) Go to the following webpage: b) Scroll down and select all of the code from "Sub emailmergewithattachments ()" through "End Sub" at the end of the code / Copy / return to Word
Word 2010: Mail Merge to Email with Attachments ICT Training, Maxwell School of Syracuse University
This procedure is credited to Doug Robbins, Microsoft MVP
Page 2
2) Create the macro in Visual Basic: a) Developer tab / Code group / Macros
Macro name: emailmergewithattachments
Macros in: All active templates and documents
Description: "This macro will complete the mail merge process when creating a mail merge to email with attachments."
b) Paste the code you copied into the Visual Basic Editor: Click the Create button. (1) The Visual Basic application opens. Delete any existing code in the Code window. Paste the code you copied from the web page into the Code window. Close the Visual Basic window.
Word 2010: Mail Merge to Email with Attachments ICT Training, Maxwell School of Syracuse University
This procedure is credited to Doug Robbins, Microsoft MVP
Page 3
Create the Directory for the mail merge using Outlook Contacts:
1) Mailings tab / Start Mail Merge group / Start Mail Merge button / Directory 2) Select the recipients of the mail merge:
This can be any of the usual sources you would use for a mail merge: Outlook Contacts, an Excel spreadsheet, Word table, Access database.
The source you use for this Directory must be the same source you are using for the mail merge.
a) Click the Select Recipients button / Select from Outlook Contacts... In the "Select Contacts" dialog box, make sure the contact folder you wish to use is selected, and then click OK.
In the "Mail Merge Recipients" dialog box you can deselect whomever you do not need to send the mail merge to.
OK 3) Create the Directory document:
a) Insert a 1 x 2 table:
One column will hold the email addresses, and one column will hold the file path for the attachment.
Insert tab / Tables group / Table button / highlight the first two cells in the grid / click the second cell to add a new table.
Insertion point should be in the first cell of the table.
b) Insert the email address merge field: Mailings tab / Write & Insert Fields group / Insert Merge Field / select Email_Address
If the document you want to send in the mail merge is the same for everyone, you can add the path to the file in this document.
If you are sending different documents to your mail merge recipients, you can add that information after merging to a new document.
When you add a path to the file, it must be exact. We will assume that we are sending the same document to everyone for this mail merge.
Word 2010: Mail Merge to Email with Attachments ICT Training, Maxwell School of Syracuse University
This procedure is credited to Doug Robbins, Microsoft MVP
Page 4
c) Add the file path to the second column: Place the insertion point in the second cell / Activate Windows Explorer Open the folder that contains the document(s) you want to attach. Click in the address bar to see the full path / Copy the selection Return to Word / Paste the selection in the second cell Return to Windows Explorer / select the name of the file, including the file extension / Copy the selection Return to Word / type a back slash at the end of the current path / Paste the selection after the slash
d) Finish and Merge the letter to individual documents: Mailings tab / Finish group / Finish & Merge button / select Edit Individual Documents... In the "Merge to New Document dialog box", choose All / OK
A new document is created with the list of email addresses and the path to the file.
e) Save the new document:
Make sure you remember where you have this document stored ? you will be prompted for it when the macro runs.
Save As / Name your file / Save Close the Directory file / close the mail merge document without saving.
Create the Email Mail Merge and run the macro: 1) Create a New document / Mailings tab / Start Mail Merge group / Start mail Merge button / Letters
a) Select Recipients button / Select from Outlook Contacts... / OK at the "Select Contacts" dialog box.
At the Mail Merge Recipients you can pick and choose who to send the mail merge to.
b) Select your recipients / OK 2) Write the letter, inserting mail merge fields, as needed.
This is a typical mail merge ? only the ending process has changed.
3) Finish and Merge the letter to individual documents: a) Mailings tab / Finish group / Finish and Merge button / Edit Individual Documents... / All / OK
Word 2010: Mail Merge to Email with Attachments ICT Training, Maxwell School of Syracuse University
This procedure is credited to Doug Robbins, Microsoft MVP
Page 5
4) Run the macro: a) Developer tab / Code group / Macros button / select the "emailmergewithattachments" macro / Run
If the macro delivers an error and brings you back to the Visual Basic window: Cancel the window Developer tab / Code group / Visual Basic button / Tools / References ? make sure "Microsoft Outlook ## Object Library" is selected / OK Close the Visual Basic window. Rerun the macro.
b) Word takes you to the Open dialog box ? navigate to the Directory document / select the file and click Open.
c) Enter a subject for the email message / OK
A message is returned indicating the number of emails that were sent. If you need to keep a copy of the document, save it, otherwise, close all documents without saving.
Create another email merge with attachments using an Excel file as the source:
The macro has already been created. Once it's created, you can use it over and over. Remember that the source for your Directory must be the same as the source for your Mail Merge
recipients.
1) Create a new Directory: a) Create a New Document / Mailings tab / Start Mail Merge group / Start Mail Merge button / Directory b) Select the recipients of the mail merge:
Remember - the source you use for this Directory must be the same source you are using for the mail merge.
Click the Select Recipients button / Use Existing List... (1) In the "Select Data Source" window, navigate to the Excel file / select the file / Open (2) In the Select Table dialog box, choose the worksheet that contains your contact information / OK
If needed, click the Edit Recipient List button / select only the recipients for the mail merge / OK
Word 2010: Mail Merge to Email with Attachments ICT Training, Maxwell School of Syracuse University
This procedure is credited to Doug Robbins, Microsoft MVP
Page 6
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- word 2010 mail merge to email with attachments
- e mailing a large amount of recipients
- what is mail merge to pdf university of aberdeen
- microsoft word 2016 mail merge
- how to copy the list of addresses from the word document
- how to send secure email
- how to mail merge with word excel
- microsoft outlook how to embed a pdf into an email message
- how to make email templates in office 365 or microsoft
Related searches
- merge mojang account with microsoft
- microsoft word 2010 free download for pc
- microsoft word 2010 free download windows 10
- microsoft word 2010 free download windo
- free microsoft word 2010 download
- microsoft office word 2010 free download
- microsoft word 2010 free
- microsoft word 2010 free download windows 8
- microsoft word 2010 free download install
- microsoft word 2010 replace words
- microsoft word 2010 free download
- install microsoft word 2010 for free