I need a macro will take details for each user in spreadsheet

[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,
Abhishe

 

[Hui]

You can use this for the first part
Export Excel Data to a Word Report

There is plenty of code here in the Forums for emailing which can be added to do the emailing part

 

[Hui]

Also

What is different in this post than the post you made yesterday at:
http://chandoo.org/forum/threads/i-...and-will-open-up-a-template-word-docum.22220/

You never responded to that post

Please don't double post.

 

[Abhiishek]

Thanks Hui