Archive for July 18th, 2007

Mail Merge Microsoft Excel file with Microsoft Word

Wednesday, July 18th, 2007

Combination of Microsoft Excel file and Microsoft Word

First, create data in Microsoft Excel (Sheet1)

Save excel file that you make.
Open Microsoft Word.
Click View, Toolbars, Mail Merge.
Create format letter as you like.
Click Tools, Letters and Mailings, Mail Merge.
Click Letters on radio button.
Click Next:
Starting document , Select recipients,
Click Use an existing list radio button,
Click Browse
Choose excel file in the directory where you save in.
Click Open and choose Sheet1, click OK.
Click Write your letter, More items
Choose one field and click Insert then click Close.
Do the same for the next field.
Click icon View Merged Data to see the result.
If you want to see next record, just click Next Record icon or change the record number.
Note:
If possible Microsoft Excel file and Microsoft Word file in the same directory
Format letter depends on your needs.