Hyperlinking e-mail addresses from a listing to show a subject lin

[Flo]

We have 2 worksheets one contain drop-down menu listing of different
selections of people w/e-mail addresses. When they select a person from the
drop-down menu an e-mail is automatically generated. Our problem is that we
would like for the Subject line on the e-mails to reflect Online Library
Resource as the wording. We are able to get this to happen on Sheet 2 when
we select (as a test) one of the e-mails and it happens exactly like we want
--- but, when we go back to Sheet 1 & select someone an e-mail is populated
w/o any verbiage in the Subject area --- I have included the formula that we
are using for the e-mail to be populated --- what have we left off --- plus,
this hyperlink does work when we select directly from Sheet 2 --- we are
hiding Sheet 2 when we populate this spreadsheet so we need to make sure that
Sheet 1 works the same --- PLEASE help us --- thanks!

=HYPERLINK("mailto:" &
INDEX(Sheet2!G:H,MATCH(Sheet1!A4,Sheet2!G:G,FALSE),2),
INDEX(Sheet2!G:H,MATCH(Sheet1!A4,Sheet2!G:G,FALSE),2))

 

[bgeier]

Try adding "mailto:[email protected]?subject=testing",


Code: