I have read the past posts and am still confused. I would like to know if anyone could help me with the following issue. I need to send out 500 letters. In the letters there will be separate areas that will need info from a Excel spreadsheet. For example, the letter will state " Dear XXX, Your Bonus Target for 2003 is XXX. This number depends on the following info - Country XXXX, Personal XXXX and Department XXX. " The X's being the info I will need to pull from the spreadsheet. I was able to use mail merge to do one letter but I was hoping there was a way to automate the process so that all 500 letters pull the needed info at once. Instead of manually doing mail merge on each of the 500 letters. Any help you could offer would be greatly appreciated.
Thank you,
Lainie