Excel Macro - Send Email and Attachments
Can someone help with the following? Starting from an excel worksheet with the following columns.
A - Note for the "Body of the email"
B - Name of person receiving email for "Body of the email"
C - Email address of person receiving email (hyperlink)
D - Due Date
E - Signature of person sending email for "Body of the email"
F - Location source of the Microsoft Office attachment to be added to email
G - Current Date
H - Status based on Current Date to Due date (New Task Assigned, Complete - No action required, Overdue, Reminder (action within 3 days of being due)
Email with attachment would be sent out based on column H
Is there any way to over ride Outlook 2003 security reminder every time?
There is also a need to make sure all recipients received their copy.
Any assistance would be greatly appreciated.