word template and excel source?

[ll]

Hi,

How to do this:
I have one letter in word template like this:
<<Date>>


Dear <<salutation>> <<last name>>,

....

( letter body part)





Best regards





and an excel file with all receiver's name and address:

Assigned firstname lastname Confirmed...

LL1,LL1 LL1 LL1

LL2,LL2 LL2 LL2



How can I print out this letter one by one with all receiver's name and
address on every letter?





Any help will be greatly appreciated!





Thanks

 

[Cindy M -WordMVP-]

Hi Ll,

and an excel file with all receiver's name and address:

Assigned firstname lastname Confirmed...

LL1,LL1 LL1 LL1

LL2,LL2 LL2 LL2



How can I print out this letter one by one with all receiver's name and
address on every letter?

You mean, like a "copies to" block? Have you tried copying the cells in
Excel and using Edit/Paste Special in Word to paste with a link? If this
doesn't help, please explain how it falls short, as there are a number of
variations we can try.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail