View Single Post
  #5  
Old October 9th 08, 04:38 AM posted to microsoft.public.outlook.contacts
Diane Poremsky [MVP]
external usenet poster
 
Posts: 12,991
Default Can I import an Excel doc into a distribution list?

No need to use VBA, unless you need it automated. Just copy the email
address column and paste into the Members field.
http://www.outlook-tips.net/archives/2004/20041105.htm

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Jami ..." wrote in message
...
That is only half true. There is no "click here and it's done" option in
Outlook to do this. However, I was looking for this info as well and
stumbled upon a pretty neat solution. It involves a VBA solution in Excel.
I have applied this today and it works like a charm. You can find the
information he

http://office-outlook.com/outlook-fo....php/m/220384/


Ads