Attaching a document to an email address hyperlinked from Excel

jakejosh993

New Member
Joined
Feb 4, 2011
Messages
2
My company uses forms with preassigned numbers to track customer complaints. Each time a complaint is called in, the intake officer uses the next available form and assigns a resolution specialist to one of each of the eight sections (so 8 individuals are responsible for completing this form).

I used a wonderfully helpful posting from this forum to create a hyperlink to email the 8 individuals assigned to the form (=hyperlink("mailto:"&substitute(a1,"",".")&"@companyname.com"). Now I'd like to take it to the next step.

MY QUESTION: is it possible to have excel/vba read the assigned report number (for instance "CA-001") and have the email's subject line read something like "You have been assigned to CA-001" -OR- even better, have a hyperlink to the document appear in the email?

Thank you very much for your suggestions!!!
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,108,995
Messages
5,526,130
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top