Send data from Excel in email from specific email account

Hello eriknokc,

Welcome to the Forum! Sending email using the ShellExecute API uses the default mailer. You can send your email to multiple recipients, do CC and BCC as well. However, your mail body is limited to 256 characters, and you can't send in HTML. This is fine for short, text only messages. If you need more then Outlook is the better choice.

I don't know where you found that second macro, but please put it back! It won't do anything because it is incomplete. It would help if you describe in more detail what you want to achieve with the email. Simply saying you want to mix and match isn't very specific.

Sincerely,
Leith Ross

Well the 2nd macro worked fine for me, but I guess that doesn't matter.

This is what I am looking for...

What do I need to add to the 1st macro is to be able to set the from field of the email to a specific email address/email account?

Hello eriknokc,

You have the variable Email following the "mailTo:" . This is what specifies the email recipient's address. What is the code not doing?

Sincerly,
Leith Ross

The Email following the "mailTo:" is for the email addresses I am sending to. I need to also specify the email address I am sending from. I have multiple email addresses that I have permission to send from and I need it to come from one specific email address.

Hello eriknokc,

You can only do that from Outlook. A macro can be run from Excel to create the Outlook Application and set up the email and send it. ShellExecute was not designed to perform that security function.

Sincerely,
Leith Ross

Well thank you for your help and information.