Automate to send message to a distribution list

  • Thread starter Thread starter Juan in msnews
  • Start date Start date
J

Juan in msnews

Hi everyone,

I use an Excel macro to send automated messages to the email addresses that
are written in certain cells. Very simple, and works great.

However, I would now like to send automated emails to distribution list from
Excel (or from any program, that's really not relevant) but I can't figure
out how to do it.

Any ideas?

Thanks, from Spain
 
The contact folder with the Distlist must be set to 'show this folder as
e-mail address book' via folder properties.

Then you can add a reference to the DistlistItem to the MailItem's
Recipients.Add function.

--
Best regards
Michael Bauer - MVP Outlook
Synchronize Color Categories & Ensure that Every Item Gets Categorized:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Thu, 15 Nov 2007 17:21:13 +0100 schrieb Juan in ms
 
Back
Top