Autofill (Excel & Word)

[Worzel Gummidge]

I have an MS Excel spreadsheet. In each column, there is info. Column A =
name, B = address, C = postcode and D = reference number. In column E, I
have a little image which, when clicked I want to do the following.......

When I click the image in column E, for example cell E1, I want it to open
an MS Word letter template. This will be a template I have designed myself.
Now, in this template, I want MS Word to automatically complete certain info
in the letter, for example, I would like MS Word to automatically complete
the name, address and reference number in the Word document, by extracting
this info from the Excel spreadsheet.

Any suggestions?

 

[Beth Melton]

Without VBA knowledge you may want to take a look at Mail Merge in
Word.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/