Automate to send message to a distribution list

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
 
M

Michael Bauer [MVP - Outlook]

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to automate a weekly task 1
Send to Distribution List in Contacts 2
add distribution list 1
Automatically send a email to a distribution list at a set time 4
Extract email addresses from Distribution LIst in Global Address List 2
Macro to remove contact from multiple distribution lists? 0
Automatically email an Excel file to a Distribution List 1
outlook distribution list 3

Top