Creating Email Links

psycoperl

Active Member
Joined
Oct 23, 2007
Messages
287
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
  3. Web
I would like to know how can I create a cell that I can use as a pseudo button (so that it would work with both Excel Apps and Excel Office 365 Online) that when the user clicks on it, it would open their email client to send the email.

Excel Formula:
=CONCATENATE("mailto:myEmailUserID@.mySchool.myUni.edu?subject=",$C$6," [FILE ID ",$H$3,"]?body=The file ", $C$6 , "-", $H$3, " is ready to be processed")

Is this possible? I saw the Insert Link option which would allow me to create a link but it would not allow me to use a formula to get the subject line or pre-set a body message.
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Dan_W

Active Member
Joined
Jul 11, 2018
Messages
380
Office Version
  1. 365
Platform
  1. Windows
Try changing the ? before body to an &. So, for example, the final output looks like:

mailto:SendToMe@MyPlace.com?subject=Discussion Topics&body=To be discussed

I hadn't appreciated that the Insert Link dialog doesn't allow insertion of the Body text. In any event, you can get the same effect by using the HYPERLINK formula:

=HYPERLINK("mailto:SendToMe@MyPlace.com?subject=Discussion Topics&body=To be discussed","Click me!")

This will (hopefully) display the hyperlinked text: "Click Me!". I haven't tested it for 365 Online, but it should work.
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,128,136
Messages
5,628,911
Members
416,352
Latest member
Lunox01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top