melodramatic
Board Regular
- Joined
- Apr 28, 2003
- Messages
- 180
- Office Version
- 365
- Platform
- Windows
I've got a hyperlink formula that is working fine, until I try to add the cc: to it, and then it flat-out bombs. I've re-written with the Excel tutorial lines open, counter ampersands, prayed and cussed, and it just won't work for me. I know it's probably a simple fix, and am hoping someone will share that fix with me.
The formula I have that IS working is...
=HYPERLINK("mailto:" & "accounting@abc.com"
& "?subject=" & "Reclassification of Expenses"
& "&body=" & "Attached is a listing of the expenses that need to be reclassified from Group-D to Group A. An explanation of each receipt is listed to go along with the totals.","eMail Accounting")
But, when I try to add the cc:, it's just failing. I've tried a couple of different ways, and in both ways, I get a #VALUE! in the cell. (on all of these, returns are added in the code for ease of reading).
=HYPERLINK("mailto:" & "accounting@abc.com"
& "?cc=" & "managerA@abc.com" & "; " & "managerB@abc.com"
& "&subject=" & "Reclassification of Expenses"
& "&body=" & "Attached is a listing of the expenses that need to be reclassified from Group-A to Group B. An explanation of each receipt is listed to go along with the totals.","eMail Accounting")
=HYPERLINK("mailto:" & "accounting@abc.com" & "?"
& "cc=" & "managerA@abc.com" & "; " & "managerB@abc.com"
& "&subject=" & "Reclassification of Expenses"
& "&body=" & "Attached is a listing of the expenses that need to be reclassified from Group-A to Group B. An explanation of each receipt is listed to go along with the totals.","eMail Accounting")
=HYPERLINK("mailto:" & "accounting@abc.com"
& "&cc=" & "managerA@abc.com" & "; " & "managerB@abc.com"
& "?subject=" & "Reclassification of Expenses"
& "&body=" & "Attached is a listing of the expenses that need to be reclassified from Group-D to Group A. An explanation of each receipt is listed to go along with the totals.","eMail Accounting")
I've tried all the formula variations above with only one email for the cc, and I still get the same error. Help?
The formula I have that IS working is...
=HYPERLINK("mailto:" & "accounting@abc.com"
& "?subject=" & "Reclassification of Expenses"
& "&body=" & "Attached is a listing of the expenses that need to be reclassified from Group-D to Group A. An explanation of each receipt is listed to go along with the totals.","eMail Accounting")
But, when I try to add the cc:, it's just failing. I've tried a couple of different ways, and in both ways, I get a #VALUE! in the cell. (on all of these, returns are added in the code for ease of reading).
=HYPERLINK("mailto:" & "accounting@abc.com"
& "?cc=" & "managerA@abc.com" & "; " & "managerB@abc.com"
& "&subject=" & "Reclassification of Expenses"
& "&body=" & "Attached is a listing of the expenses that need to be reclassified from Group-A to Group B. An explanation of each receipt is listed to go along with the totals.","eMail Accounting")
=HYPERLINK("mailto:" & "accounting@abc.com" & "?"
& "cc=" & "managerA@abc.com" & "; " & "managerB@abc.com"
& "&subject=" & "Reclassification of Expenses"
& "&body=" & "Attached is a listing of the expenses that need to be reclassified from Group-A to Group B. An explanation of each receipt is listed to go along with the totals.","eMail Accounting")
=HYPERLINK("mailto:" & "accounting@abc.com"
& "&cc=" & "managerA@abc.com" & "; " & "managerB@abc.com"
& "?subject=" & "Reclassification of Expenses"
& "&body=" & "Attached is a listing of the expenses that need to be reclassified from Group-D to Group A. An explanation of each receipt is listed to go along with the totals.","eMail Accounting")
I've tried all the formula variations above with only one email for the cc, and I still get the same error. Help?