I have looked at a solution throughout the forum but haven't found exactly what I am looking for.
I want to be able to send multiple personalized emails where I have the option of updating the Subject, Email, Greeting, and Body.
See attached. I also want the option to automatically send or to save as a draft in Outlook. For example, in the attached, the Subject in B1 is "Thank You", and Auto Send set to "No". The Email, Greeting, and Body are in Columns B,C, and D. You shouldn't have to hard code anything in the VBA for the email and there will be no attachment. Also, how would this work with an Email Signature? Should this be hard coded or will the Signature automatically appear based on your Outlook settings?
In the attached example, for Row 4, I want the Outlook email to generate the following:
To: (Email Address in Cell B4)
Subject: Thank You
Marie,
Thank you for your business. Please let us know if we can further assist your business needs.
Bookmarks