 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / September 2004Export Distribution list?
Folks: My client has an extensive Distribution list in Outlook. I need to have that list (and only that list) as a CSV file for an email campaign. How can I get that? He has sent me the entire contact list as an XLS file, but I cannot find a field in that list that would identify the distribution list. If there is a way to do that, I would be grateful for some help. Solving the problem this way would eliminate my having to bug the client for yet another try! 8)  SignatureMurray Ask your client to save the DL as a text file with the File | Save As command and send that file to you. You can open it in Notepad to clean up the top a little, then open the cleaned up file in Excel as a tab-delimited file. SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > Folks: > [quoted text clipped - 7 lines] > this way would eliminate my having to bug the client for yet another try! > 8) Thank you Sue! How would he specifically select that DL to export? SignatureMurray > Ask your client to save the DL as a text file with the File | Save As > command and send that file to you. You can open it in Notepad to clean up [quoted text clipped - 12 lines] >> problem this way would eliminate my having to bug the client for yet >> another try! 8) Did I say "export"? No. I said use the File | Save As command, which is available on any open or selected item. DLs do not export when contacts folders are exported, unless the target is a .pst file. SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > Thank you Sue! > [quoted text clipped - 16 lines] >>> the problem this way would eliminate my having to bug the client for yet >>> another try! 8) Oops! OK - thanks! I'll give that one a go. SignatureMurray > Did I say "export"? No. I said use the File | Save As command, which is > available on any open or selected item. [quoted text clipped - 22 lines] >>>> Solving the problem this way would eliminate my having to bug the >>>> client for yet another try! 8) And, would there be any way to tease the distribution list assignment from an export of the entire set of contact data? SignatureMurray > Ask your client to save the DL as a text file with the File | Save As > command and send that file to you. You can open it in Notepad to clean up [quoted text clipped - 12 lines] >> problem this way would eliminate my having to bug the client for yet >> another try! 8) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.