Hello All,
This is what I require. Example:
I have an Excel sheet with several columns. Each row contain information about an specific client. Each row contain 2 email addresses (client and Secondary contact). Once the macro runs this is what it will be required.
1 - Create email to be sent at once to the 2 email address in the same row, in different columns. (instead of sending the email automatically, I want to display it first)
2 - As an attachment it will have to create a new Excel document with row 1 and the row according with the 2 email address.
3 - Set the subject always to be the same (Ex: Notification .....)
4 - In the body message, it will start with HELLO , I would like for the name of the client to be put automatically after that
5 - The email will contain the same body message (EX: This is a test ....)
6 - Is there a way to setup an signature (EX: NAME, PHONE)
Thank you so much in advance. I would appreciate all the help
Bookmarks