Word 2007

Hello Jane,

Hope you enjoyed your Microsoft Word Advanced course with Best STL.

Thank you for your question regarding working with mail merge formulas.

For an experienced Excel user creating formulas is usually fairly simple. In Word, however, creating formulas seemingly becomes a more complex process.

To make this as easy as possible I have created three Word files for you. One with the mail merge created. One which is the recipient data file and the third file containing a few notes.

I would suggest you open a new folder and place all 3 files into it. Then open the New Salary Memo file, click Options... and Enable content first, then go to the Mailings ribbon and click the Start Mail Merge button and select the Mail Merge Wizard. If you are on step 1 then you will have to go through the process of selecting the Recipient list again. Hopefully this won't be the case. The name of the recipient list is called Sales Staff List.

Once this step is complete and you are at the stage of previewing the letters you will see that the text in the first paragraph differs from person to person and the increases are different for some. Take a look at the Merge Code file for more info.

To view the code in the letter simply use the ALT+F9 shortcut as a toggle between code and results.


I hope this helps to resolve your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer