macro to link data to create an email

M

Mr Marvin

New Member
Joined
Sep 8, 2021
Messages
31
Office Version
  1. 2019
Platform
  1. Windows
=HYPERLINK("mailto:" & G10 & "?subject="& G11 & "& Output Temp!A1=" & G12, "Hello kris click me")

i have managed to create macros which create a template for an email. Using the above hyperlink function i can open up an email and prepopulate the email and subject but i am unable to automatically pull the data from OutdoorTempA1 which holds the body of the email.

is there a macro which can automate all this in one click.

TIA
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
You must log in or register to reply here.

Similar threads

A
  • Solved
Sending hyperlink filepath via email
Replies
8
Views
361
AndyEd
A
T
  • Solved
Sending daily emails based on criteria, with email body corresponding to parallel cell which holds email address(es)
Replies
1
Views
775
twinwings
T
H
  • Question
VBA split file based and send splitted file in separate emails
Replies
0
Views
157
harmless92
H
A
  • Question
Follow a Hyperlink that creates a new Outlook e-mail message by using a VBA Excel Macro.
Replies
8
Views
1K
Agente442
A
T
  • Solved
Auto Email list
Replies
2
Views
385
Tablecloth98
T

Forum statistics

Threads
1,215,051
Messages
6,122,872
Members
449,097
Latest member
dbomb1414

Share this page

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
Back
Top