Hello,

I run an Excel macro with vba statement that send different workbooks to
different people via Outlook Exchange server in my company:

Workbook.Open Filename: = "filename report for Person 1"
ActiveWorkbook.sendmail Recipients: = "Person 1 e-mail name"
Workbook.Open Filename: = "filename report for Person 2"
ActiveWorkbook.sendmail Recipients: = "Person 2 e-mail name"
Workbook.Open Filename: = "filename report for Person 3"
ActiveWorkbook.sendmail Recipients: = "Person 3 e-mail name"

When it runs I get a message box with title "Microsoft Office Outlook" that
says:

A program is trying to send an e-mail message on your behalf....

Each time I have to click the "Allow" button to send each email with
attachment. Do you know how I can avoid getting this warning?

Thank you very much!

Craig

Hi Craig

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Craig" wrote in message ...
Hello,

I run an Excel macro with vba statement that send different workbooks to
different people via Outlook Exchange server in my company:

Workbook.Open Filename: = "filename report for Person 1"
ActiveWorkbook.sendmail Recipients: = "Person 1 e-mail name"
Workbook.Open Filename: = "filename report for Person 2"
ActiveWorkbook.sendmail Recipients: = "Person 2 e-mail name"
Workbook.Open Filename: = "filename report for Person 3"
ActiveWorkbook.sendmail Recipients: = "Person 3 e-mail name"

When it runs I get a message box with title "Microsoft Office Outlook" that
says:

A program is trying to send an e-mail message on your behalf....

Each time I have to click the "Allow" button to send each email with
attachment. Do you know how I can avoid getting this warning?

Thank you very much!

Craig