=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
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