Create MS Outlook Email from Excel and Save to Draft Folder

Good day Mr. Excel Team,

I need to update a rather robust Excel list that has multiple fields with new information. I'd like to create an Excel form/spreadsheet with the required info, have a macro create the email (include To, cc, bcc, Subject, body of text, attachment) and have it saved to the Draft folder. Subsequently, I'd like to email all draft items at once.

I had a macro for this once long ago in a prior life but have moved on and lost it. I know it's out there somewhere and any assistance pointing me in the right direction would be of great help.

At some point, I'd like the responses delivered in such a way that I can simply import them into the main spreadsheet and review for accuracy, but that is another thread.

Thanks in advance for your time and consideration. I continue to be amazed at the skill and expertise of the members of this forum.

Respectfully,

jski

There are a number of variations in the type of email you have outlined. If you need a custom solution, then please load your base file as per the yellow banner above. In the meantime, here's a file from another project that may meet your needs.

Please Login or Register  to view this content.

I did some further research to make sure I meet your requirements, and found the following line of code not included above accounts for the creation of a draft in Outlook:

Please Login or Register  to view this content.

Use this line instead of the

Please Login or Register  to view this content.

line.