Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
eli eli is offline
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 599
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I easily create an Outlook distribution list from excel? Lisa Excel Discussion (Misc queries) 1 June 13th 08 04:25 PM
can i create a distribution list between excel and outlook? distribution list Excel Discussion (Misc queries) 8 May 6th 08 04:59 PM
Creating Outlook Distribution List Ed Kura Excel Discussion (Misc queries) 2 July 19th 05 01:56 PM
How do I create an Outlook distribution list from an Excel column Mike Officer Excel Discussion (Misc queries) 2 June 24th 05 04:45 AM
Send mail from vba with the outlook distribution list eli Excel Programming 0 January 2nd 04 10:21 PM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"