Sending Excel Workbooks to Outlook people automatically

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert name and adress from a list in a word document 1
Sending mail 5
Sending Email using Lotus Notes 1
Merging from an Excel file with graphics 1
email workbooks to three people 0
Someone knows how to add hyperlinks to hours to schedule an appointment? 0
Help on mail 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0

Top