Attaching a document to an email address hyperlinked from Excel

[jakejosh993]

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