Hi,

I have a Macro for sending outlook, but i want to modify it using attached mail templates:

Template 1, if there is 1 item that is more than 30 days (column C)
Template 2, if there are 2 or more items that are more than 30 days
Template 3, if there is no item that is more than 30 days.

Subject also varies depending on the template.

Thanks,

AkiOutlook sending2.xlsSample templates.docxSample mails.xlsx