C
Craig
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
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