existing macro to send emails to multiple recipents needs fix

Hi all,

I have a macro in place that sends emails based on hold codes (column F) to one email address identified in column K however I need add one more field to be addedd as "TO" and three "CC" fields on the email.

Also, I need to use the default signature while sending emails.

Could someone kindly help me with this?

I have attached my template with code on this thread.

Regards,
Kiran

Put this in Master Sub

Please Login or Register  to view this content.

This will preserve the default signature if you have one set up in Outlook for new emails.
Sub Send_mail() procedure

Please Login or Register  to view this content.

Thanks Alpha,

I tried your suggestions but unfortunately I could not have the signature added (may be because, I am not using HTML format for my emails) also,
whils .send is enabled, outlook is unable to send Emails.

I have a signature setup for my outlook

Please help

It works for me using your workbook. My Outlook is set up for plain text. You have to .Display first (before adding the email body text) for it to get the default signature.

Also, make sure the email address in K2 is only one address with no trailing semicolon ;

Please Login or Register  to view this content.

Thanks a lot, its working fine now