Excel Tips - Create Email Hyperlinks that Dynamically Include Recipient, CC Line, Subject and Body

[@lionlsri]

Helpful for me and save my time. Istit possible to attach an attachment?

[@tanseygreen]

Excellent thank you

[@mcgarvey1986]

nice vid - I'm having trouble including a hyperlink in the body of the text - any ideas?

[@CareerSolutionsforToday]

Hi there, where do you want the email to link to? Is it a website? If yes, you should be able to just include the website URL so readers can click it.

[@lydethful]

Great tip, does it work with Gmail?

[@CareerSolutionsforToday]

It should work with whichever your primary email launches as =)

[@cindyeverythang]

Great video!! How can i make it work for google sheets?

[@CareerSolutionsforToday]

Thank you so much for the comment. I plan to work on Google Sheets videos in the future, but I haven't been too exposed to that system yet. More to come =)

[@user-sg7ze6ts4n]

I tested this formula on various character numbers, and it seems like the character of email addresses, subject and body text all combined needs to be below 255. Am I missing something? great video btw

[@CareerSolutionsforToday]

Hey there, you are correct that there are character limitations for Excel. However, you should be able to remedy this to a large extent using cell references. Does this help?

[@user-sg7ze6ts4n]

I think I am already using cell reference similar to your video, unless I am missing something. Do you have a video showing this email hyperlink feature for multiple emails (over 100 characters) subject (50 characters) body text (200 characters?)

[@CareerSolutionsforToday]

@@user-sg7ze6ts4n I can make a new video on this over the weekend to try and help =)

[@CareerSolutionsforToday]

@@user-sg7ze6ts4n Hey there, so I tested this out and plan to make a video on it but for now I wanted to share what you can do for multiple emails is use a cell range and you can do the same for the body of the email. So for example, you can write out the email body in Excel and reference the cell value in the HYPERLINK function. Instead of what I have in my video where I type it out, you can add "&body="&B2 assuming cell B2 is where the body text was. Does this help?

[@user-sg7ze6ts4n]

Hi! and thank you very much for your help! yes, I have been using cell reference instead of typing out the body, and also using cell reference for the emails, subject, etc. but I think it’s still counting the characters of the reference cells. I counted the characters of the reference cells, and turned out the only hyperlinks that worked were the ones that had characters less than ~250 when combining the characters of email addresses, subject and body. I forgot if it counts the characters of the cell with the hyperlink or not. I hope there is a way around it!

[@ShabreenShabbu-sq1bg]

I'm getting an error like" the address of the site is invalid, please check and try again ", do u have any idea about this

[@CareerSolutionsforToday]

@@ShabreenShabbu-sq1bg Hey there, want to copy and paste the formula you used and I can take a look?

[@Limpeh-fb6rb]

hi bro how do i add multiple cc?

[@CareerSolutionsforToday]

Hey there, if you check out the final section of the video I cover creating a link that emails multiple people. You can utilize that same process in the formula for the CC section. Let me know if that helps.

[@BenakRobert]

Any tips on creating line breaks in the body section? Google is returning & %0D%0A & as an answer but I can't seem to make it work.

[@CareerSolutionsforToday]

Try CHAR(10) for the line break. It is the way to add line breaks in Excel formulas.

[@mYTHklm]

Good video

[@michaelallison902]

How would you incorporate the date in the subject text and body text?

[@CareerSolutionsforToday]

Do you mean have it added automatically based on current date or manually entering it?

[@michaelallison902]

By a date entered in my spreadsheet, in cell A1 for example. Will this work with VLOOKUP?

[@CareerSolutionsforToday]

@@michaelallison902Instead of using VLOOKUP, have the date in a cell and reference that cell in the body of the email if that is where you want to place the date. Like we did for the subject line using a cell reference for name. Let me know if that helps =)

[@JohnKaur]

Is there a way to attach a file doing this?

[@CareerSolutionsforToday]

Hey there to the best of my knowledge you would need VBA to add attachments as well. Looking to add that in a future video.

[@yogitabhopatkar1916]

Unable to add mote than 3 email IDs. Any idea why??

[@CareerSolutionsforToday]

Hello there, did you perhaps only highlight or include 3 emails in the function drafted?

[@zoltankovacs375]

@@CareerSolutionsforToday Hi i have the same issue and can't add more than 1 address into "to" neither into "cc" since i get "#Value!" error. Any idea why? use this code: =HYPERLINK("mailto:"&TEXTJOIN(";";TRUE;D8:E8)&"?subject="&F8&"&cc="&$E$3&"&body="&E4;"send email")

[@DavidMartin-bq3uw]

Is there a way to make the body dynamic using this? I keep getting a #VALUE! error. =HYPERLINK("mailto: "&P4& "?cc="&Q4& "&subject=Disconnect Insight for "&R4& "&body="&O4,"Email "&R4)

[@DavidMartin-bq3uw]

It might be a character limit.

[@CareerSolutionsforToday]

Hey there, the formula appears correct and is working for me. Do you maybe have other formulas in the cells you are referencing? The way you have the body setup it is pulling from a certain cell, so it would depend on what is in that cell.

[@user-sg7ze6ts4n]

what no one talks about is that the character combination of subject, body text and all email addresses need to be below 255 characters which makes it very challenging, and you might as well use VBA