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,

"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.