Excel Database merging to Word letter

[mikecincotta]

I have a templated letter in MS Word and information stored in an Excel file. I am wondering if there is a way to automatically merge certain fields in the Excel database to replace certain portions of the Word document. I also need to print an envelope for each modified letter. Does anyone know how to accomplish this? I am pretty familiar with setting up a mail merge but don't know how to automatically insert to a Word document.

 

[mikecincotta]

That isn't doing the trick. It ends up looking like this....

company totaling ${MERGEFIELD Amount\# $#,##0.00}. These assets are

Doesn't insert the amount at all

 

[Smitty]

Unfortunately, I haven't worked with Word docs in a while, so I'd have to mess around with it. Check your PM for my e-mail address - You can send me the Word doc and data file, but because of my current schedule I can't guarantee to get to it any time soon.