Automate to send message to a distribution list
 

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

Automate to send message to a distribution list
 

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