The story goes - I have been using Excel VBA from http://www.rondebruin.nl/ to send specific attachments to specific recipients once a month. Column B has the recipient email and columns F-K have the attachment hyperlinks.

We've decided that it would be easier to instead send the recipients hyperlinks to their network directory, so that they can peruse the files at their leisure, among other reasons. So, what's the best way to send ~20 emails to different recipients and groups of recipients where each group or individual will have a link to a network share that WILL NOT CHANGE each month. The variable will be in the subject line where I will want a current date field and possibly the same in the body.

I'm thinking that the body could simply be a hyperlink that said "Click here for the most recent summary reports". I still want the subject line to contain a current date.

I don't even know that I need VBA. Maybe there is an Outlook plugin that could handle such a thing? Thanks for any leads.