I'm issuing client billing via email. Depending on their preference, they receive attached bills via email (Outlook 2010) in PDF or Excel 2007 format. I just began using the quick insert button to fill in the email body, since every month, it's the same. This will save tons of time.

I use and write macros in excel, but haven't tried to link it all together. Now that the idea is there, can someone help me figure out if it's possible? I know I can run a macro from Outlook, but am not sure if that's how it's go about it, or is there a way for the excel hyperlink to open the email, select the designated quick text, insert the attachment then stop to be reviewed before being sent?