I need a macro will take details for each user in spreadsheet and will open up a template word docum

[Abhiishek]

Hi Friends,

I need a macro will take details for each user in spreadsheet and will open up a template word document which can be a letter for example.
It will then populate the document with data such as name, address etc and save it as a pdf. This pdf will then be attached to an email and sent automatically to each user.
I tried to find vba code on google. but could not find . i have found a web site http://www.techflutter.com/macro5.php . I have same requirement as it is defined. please help me.

Thanks in advance

Regards,
Abhishek

 

[Hui]

You can do some of this with the post I wrote at:
http://chandoo.org/wp/2011/02/17/printing-excel-reports-via-a-word-document/

The emailing could be added from other posts here where that has been discussed before