Vba to mail merge data in excel into word and attach it as an email attachment in pdf form

Hello Friends,

I have some data in excel, I am doing a mail merge. The data is in columns A:G. Column G has the email addresses and would like to send each mail merged letter to that email address.
The letters should be mail merged in to individual work documents and saved as pdf then send to the respective email addresses. Kindly assist.

Think Ron DeBruin's website has something that might help - check it out...

http://www.rondebruin.nl/win/section1.htm