Automatically email an Excel file to a Distribution List
 

I have no experience with setting something up in Outlook to automatically
send files. To clarify, this is what I would like to do;

Three time a week send out an Excel spreadsheet in an attachment to an email
distribution list I have created. The Excel spreadsheet is updated several
times a day, therefore it isn't a file that contains static information.

Is there a way of accomplishing this through Outlook?

I would greatly appreciate your help.

Thank you,

Automatically email an Excel file to a Distribution List
 

"Claire" wrote:

I have no experience with setting something up in Outlook to automatically
send files. To clarify, this is what I would like to do;

Three time a week send out an Excel spreadsheet in an attachment to an email
distribution list I have created. The Excel spreadsheet is updated several
times a day, therefore it isn't a file that contains static information.

Is there a way of accomplishing this through Outlook?

I would greatly appreciate your help.

Thank you,

This is an example of a simple function


Sub SendExcelReport()
Application.Dialogs(xlDialogSendMail).Show
End Sub

You must to pu it in your Macro Peronal Book, or in the file that you want
to send.