Auto Send Email With Attached Word Doc Created From Merge

[superjew11]

I have an excel file. This file has 4 columns - sign, first name, last
name and Email.

My goal is to create a button on each line (or link) that will
automatically create an email using the email address in that record.
Not only will it say Dear first name and last name, but it will also
have a word document attached. This word document will automatically
generate with the sign number and save itself as sign###.doc. (# =
number in the sign field)

The email will then open in outlook with:
Subject of - "Testing 123"
Body of - "Dear First name and last name,"
Attachment of - "sign###.doc" .

Does anybody know if this is possible? If so, what is the code that i
need to use.
Also, I am not a VB expert, but I know my way around macros and
excel.

THANKS IN ADVANCE!

 

[Ron de Bruin]

Hi

Start here
http://www.rondebruin.nl/mail/folder3/message.htm

If column D is the sign column

Try this line for the word doc (change the path)

.Attachments.Add ("C:\sign" & cell.Offset(0, 2).Value & ".doc")