Hello All,

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.

Thanks again!

Sorry if this response is late or useless, but there's a program called ClickYes that you can use to get around the security prompt

http://www.contextmagic.com/express-clickyes/

However this is just a workaround, you can't actually avoid the security prompt unless you recode your application using an object library like Redemption which works outside the Outlook object model.

Otherwise I have some sample code you can use to start with: http://www.codeforexcelandoutlook.com/SendMessage.html

HTH,
JP