• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Outlook Email Template Format

Dafe

New Member
Hello Deepak
Can you please help me to adjust the attached file. I am trying to create an email template in excel to send manually to individual customers.
Can you please help me to modify the code below to include all the information in the body of the outlook email. The outlook template should be similar to the attached image template file. This is my code:
=HYPERLINK("mailto:"&F2&"?subject="&G2&"&body="&H2,"Send Mail")
Please download the sample excel file and the outlook email template image and let me know if you can fix this bug or maybe make use of VBA to format the outlook message template.
Thanks for your time and I await your feedback.
Regards
 

Attachments

  • ShipTrack.xlsm
    9.7 KB · Views: 3
  • Excel-Email-Template.png
    Excel-Email-Template.png
    156.9 KB · Views: 2
Back
Top