using outlook distribution list from excel vb
 

hello all

How can i send mail from vba using the outlook
distribution list, i need this because I have a long list
to mail.


regards.

using outlook distribution list from excel vb
 

Eli

See here for the basics of sending email from vba

www.dicks-clicks.com

and when you set the To property of the MailItem object, set it to the name
of your distribution list, just like you would for a single recipient.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"eli" wrote in message
...
hello all

How can i send mail from vba using the outlook
distribution list, i need this because I have a long list
to mail.


regards.