slamet Harto
09-16-2009, 07:29 AM
Hi there,
This is what I've to send mail using excel.
I want to avoid outlook security message by adapting ClickYes from Article page
http://www.vbaexpress.com/forum/showthread.php?t=9545
I get an error message on this line:
Sub SaveAttachmentRule(myItem As Outlook.MailItem)
and it says When you know the lines were such a message would pop up, all you have to do is adding a line of code with a call to the 'PrepareClickYes' routine in front of that line (And after that line a call to the 'PerformClickYes' routine.).
I believe you can advise where to put these lines (PerformClickYes & PrepareClickYes)
Please find the attached for your reference
Appreciate for your reply.
Regards, Harto
This is what I've to send mail using excel.
I want to avoid outlook security message by adapting ClickYes from Article page
http://www.vbaexpress.com/forum/showthread.php?t=9545
I get an error message on this line:
Sub SaveAttachmentRule(myItem As Outlook.MailItem)
and it says When you know the lines were such a message would pop up, all you have to do is adding a line of code with a call to the 'PrepareClickYes' routine in front of that line (And after that line a call to the 'PerformClickYes' routine.).
I believe you can advise where to put these lines (PerformClickYes & PrepareClickYes)
Please find the attached for your reference
Appreciate for your reply.
Regards, Harto