Does the table of information have an existing header row?.
Which sheet in the Excel file contains the table of information?.Click Open when ready to read the contents of the Excel file.Ī dialog box will appear requesting two pieces of information about the data: By clicking the “ Select Recipients” button we can pull information from the Contacts feature of Outlook, create a new list of dynamic data directly in Word, or what is the most common option, selecting content from an Excel table.īrowse out to the location of your Excel file and select the file.
The next step is to point to the source of the dynamic data.
MAIL MERGE WORD FROM EXCEL PDF
The results of the Mail Merge can be sent to a printer, generated as PDF files, or automatically sent out as email messages through your default email application. The dynamic content would be data that is unique to the reader, like their name, address, medical information, or purchase history.īy placing the static information in Word, then storing the dynamic content in an Excel table, we can strategically place connectors throughout the Word document that will extract from the Excel table, one row at a time, information to complete the Word document.Įach iteration through the Excel table will produce a separate and unique version of the Word document. In the case of a form letter or mass email, the static content would be all the information that is the same for each recipient, such as announcements, agendas, news stories, etc. The purpose of Microsoft Word’s Mail Merge feature is to reproduce a document, envelope, email, or label which contains a combination of static ( i.e., same every time) and dynamic content.
0 kommentar(er)
