Sending Outlook emails containing Excel data

Hi,

When creating individual Outlook emails for several people from within a looping macro, I have generally used the third party software 'Click Yes' to automatically click the Yes button when the warning message about the system potentially sending viruses pops up and gets in the way of the automated process.

Does anyone know if there is anything in Microsoft's standard toolset or syntax which would avoid having to resort to third party tools? It's sometimes an added complication where the user does not have Click Yes.

Usual TIA

Not that I am aware of... the only alternative approaches that I know of are

a) Redemption

b) CDO

I generally adopted CDO myself but obviously that requires having access to certain bits of info - ie smtpserver etc...

I suspect you have the page bookmarked already Ron de Bruin's page covers both of the above (and clickyes):

http://www.rondebruin.nl/mail/prevent.htm

(I think anything else would be considered circumventing security....)

The security warning came in with one of the SPs on 2000 I *think* ...