Share via

Hyperlink to send email with table as email body

Anonymous
2021-05-18T15:30:42+00:00

Looking to create send email hyperlink on all H column if customer email is inserted in columns E. 

Specific task to automate sending 'pickup notification emails' to customers based on the product and time-slot booked.

Below are the rows: 

A - Customer name

B - Tour Product

C - Tour Option

D - Time-Slot Selected

E    - Pickup location

F- Booking Reference

G- Customer Email  

H  - 'Send Email' hyperlink 

*Each columns will have customer booking details as per Row titles. 

If customer email is entered in columns G, a 'send email' hyperlink will appear which will automatically pickup email subject and email body based on product and time slot the customer is booked on. 

[Email body example below]

Subject: Pickup Information for {Tour Product}

Email Body:

"Dear {Customer name}; 

Thank you for booking {Tour Option}. Your pickup will be between 7.30 AM - 8.00 AM. 

If you have not selected, you can choose from below add-ons to your tour.

No. Add-ons Fee
1 ABC XX$
2 DAB XX$
3 ZAC XX$

For any assistance please don't hesitate to contact us."

Would appreciate if anybody has ever setup an excel in this way; 

thanks.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2021-05-21T12:40:29+00:00

Hey Neha,

Yes and thank you. After hours of fiddling around, I got it to work perfectly. However, at the end full body text that I created, not all the text strings were getting emails due to 255 character limit.

Anyways, shifted to Google Sheets instead due to the problem.

My feedback would be to fix the character limit. Thank fully other sheets support it.

regards,

Syed

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-05-21T08:44:44+00:00

    Hi Huxky,

    Did you check the above reply? If you still need help. please update us.

    Regards,

    Neha

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-05-19T08:47:59+00:00

    Hi Huxky,

    To achieve your requirement, you can use HYPERLINK function to send email from Excel. Hyperlink function can handle “mailto” URL property and can be used to make a hyperlink that would automatically construct the email.

    For the detailed steps and information, please check the following link. The link contains a YouTube video which will guide you through the process and it also has a sample workbook at the end of the article.

    Send Email from Excel with a Hyperlink

    Third-party link disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

    Regards,

    Neha

    Was this answer helpful?

    0 comments