can I send a spreadsheet to an Outlook distribution list?

[4281967]

I would like to include code in a macro where I could send the active spreadsheet to an Outlook distribution list.

Is this possible?

Also - would like to be able to customize the subject line.

I am currently sending the spreadsheet using this:
ActiveWorkbook.SendMail Recipients:="email@address"

However, would really like to use a distribution list since there are several hundred recipients.

 

[Gavona]

I am pretty sure I have done this using a Personal Distribution List created in Outlook. In this case you wouldn't need the @address part.
I have also used a list of email addresses. For me a cell in the workbook would contain the addresses with ; as a separator. The trick there is that the recipients field must be an array.
Check out FAQ if you want text in body of email otherwise:
I started a thread "Getting Values into an Array" 0n 3/10/03 that pretty much covers your issues.
or much more recently I replied to "Excel 2003 - automate multiple sheet creation" with some code that would help you.

I must find out how to post links to threads!

Thanks,

Gavin

 

[Gavona]

thread707-1144346
[link]thread707-495489[/url]

Thanks,

Gavin

 

[4281967]

Thanks -

I found an eaiser way though...

I used this:

Application.Dialogs(xlDialogSendMail).Show arg1:="Outlook dist List", arg2:="Email Subject"


this worked