Automatically email an Excel file to a Distribution List

  • Thread starter Thread starter Claire
  • Start date Start date
C

Claire

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 said:
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,
Click to expand...

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.
 
Back
Top