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