macro to email Excel file

C

Cam

Hello,

I have a macro in Excel to update data, then email the updated file to
people on the distribution list. The problem is once the macro is ran, it
popup a screen asking whether it is ok to send the email out (must be a
security reason in outlook?). I want to put in the code to by pass the popup
cause I want the macro to run automatically during the weekend.

Thanks
 

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

send attachment from outlook automatically 2
To Enable Macro in Excel. 2
Email individual sheets from an excel file 3
Export Macro to new Workbook based on Email Address 7
Email Macro-using range for email address,ccc,bcc,subject and body.Office Outlook as email 3
How to Unlock Excel Workbook protected by MACRO Password 6
Macro for Opening Reuters, Opening Excel File, Closing Excel File 2
Need to fix macro to send workbook via email 1

Top