MACRO to create email with attachment

[fulgencioclarissa]

Does anyone know a Macro that can automatically create outlook email, with the following characteristics.

1. "Status" is either in-progress or not started (exclude other categories)
2. Automatically attach file (in table or excel attachment)
3. Attachment in #2 will include selected (NOT all) columns only
4. Separate emails will be generated for each unique "TO:" recipient, and will copy "CC:" recipients
5. Assign a default email content:


"Dear <predefined name>,

<default email content>
<attachment>"


Hope you can share your expertise on this… Thanks in advance…

[NeedForExcel]

This might help -

http://mrspreadsheets.com/1/post/201...ttachment.html