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

Try adding ?subject=testing",


Code:
--------------------
=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)) & ?subject=testing",
--------------------


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=547894