Populate Word document from Excel spreadhseet

[shabbaranks]

Hi,
I was wondering what the easiest\preferred method is to populate a Word document from an Excel spread sheet is?



The idea being I have a template document in Word which has a field of a company name. What I would then like to do is based on that company name pull in all the other fields on that Word doc which relate to that company name within Excel.

Thanks

[Charles Kenyon]

Simplest method is Mail Merge. Under find recipient on the Mailings Tab, call up your company name. That is, the company name is simply one of the merge fields.

00 deleteme 2.png

You can, if you want, restrict the search to one field.

00 deleteme 1.png

I have a number of templates that I use that incorporate an AutoNew macro that automatically attaches the prefered data file in Excel to the new document when a document is created.