Tuesday, January 26, 2010

Create Letter Template for Microsoft Word and MySQL Server Mail Merge

As we know, The template is important in Mail Merge. We make the letter template in Microsoft Word. Later this template can produce a variation data from the database (we use MySQL Server as Mail Merge data source).

OK, let just do our next step to create Letter Template for Microsoft Word.





1. Create the letter by manually type the word we need. We can also use Formatting Text in this Template.



2. Choose the source of data by click More Items



3. Put the Cursor at the right place to put the Data on letter, and then insert Field from the Table by click Insert.




5. Result of the Inserted Field






6. Fix your template by add neccesary field.
7. The Final Result of the Mail merge Template:





Next Step : Preview the Mail Merge Final Result.

Possibly Related Article



2 comments:

Data Center Monitoring said...

Great post. Actually I am using SQL. Can it affect my all data and access controls using MySQL instead?

web design hampshire said...

Thanks for sharing. Actually I am using SQL and I can easily connect it to word 2007.