add subject to email created by vlookup (1 Viewer)

smiler44

Registered User.
Local time
Today, 09:15
Joined
Jul 15, 2008
Messages
641
I have a vlookup formula that creates an email and fills in the email address that can vary. I now want to add a subject to the email but the subject varies and also I don't want the subject to be shown as part of the vlookup result.

this is the vlookup formula I have, how do I add the subject to the email from sheet1 cell A3

=HYPERLINK(CONCATENATE("mailto:",VLOOKUP(H16,'1141 lookup'!AA:AF,5,0)),VLOOKUP(H16,'1141 lookup'!AA:AF,5,0))


thank you in advance

smiler44
 

Rx_

Nothing In Moderation
Local time
Today, 03:15
Joined
Oct 22, 2009
Messages
2,803
Working on a deadline, could you, would you please upload a tiny sample with just enough to get the point across?
Thanks!
 

smiler44

Registered User.
Local time
Today, 09:15
Joined
Jul 15, 2008
Messages
641
RX_ your post has reminded me i had made the psiot asking for help.
I got the help needed. I will try to post the solution as it's at work and I'm at home.
Sorry i should have posted that its resolved

smiler44
 

smiler44

Registered User.
Local time
Today, 09:15
Joined
Jul 15, 2008
Messages
641
this formula opens up an email, fills in the to address and adds a subject line
=HYPERLINK("mailto:"&VLOOKUP(A3,'1141 lookup'!AA:AF,5,0)&"?subject="&VLOOKUP(A3,'1141 lookup'!AA:AH,7,0),VLOOKUP(A3,'1141 lookup'!AA:AF,5,0))

this one does the same as above but also adds the body of the email
=HYPERLINK("mailto:"&VLOOKUP(A3,'1141 lookup'!AA:AH,5,0)&"?subject="&VLOOKUP(A3,'1141 lookup'!AA:AH,7,0)&"&body="&VLOOKUP(A3,'1141 lookup'!AA:AH,8,0),VLOOKUP(A3,'1141 lookup'!AA:AH,5,0))



the subject was a cell that was being pre populated by the use of a macro to get the order number and the body was a cell that again was pre populated but did not use a macro, it was just pre populated

smiler44
 

Users who are viewing this thread

Top Bottom