Excel and Outlook Integration For email sending with signature file

[Data_Analyst]

Hello,

Every time I send an email through outlook, I have it designed so a signature appears at the bottom stating my name, department, etc...

I wanted to integrate outlook and excel for easier email sending.

I used the following thread to create my email application...

http://www.excelfox.com/forum/f2/excel-template-macro-sending-mails-attahment-thru-outlook-142/

The only issue now is the signature does not appear at the bottom.

Is there a way I can use the html signature file at the bottom of my email?

Thanks!

[Data_Analyst]

I figured it out...

Instead of programming a separate .html file for the signature and the program to capture, I opted to go with a sendkey method

Here's my code...

'Goes to the end of the current email (so signature appears at the bottom)
SendKeys "{PGDN}", True

'Goes to the insert tab in the toolbar
SendKeys "%i"

'Selects the signature
SendKeys "s"

'Press enter to insert the signature
SendKeys "~"


Hope this helps everyone...


Thanks!

[Admin]

Hi,

Thanks

[Excel Fox]

You can use this link (http://www.excelfox.com/forum/f18/send-outlook-mail-signature-range-excel-multiple-email-ids-304/)