CFD Online Logo CFD Online URL
www.cfd-online.com
[Sponsors]
Home > Forums > General Forums > Lounge

Distribution list import from excel to outlook

Register Blogs Community New Posts Updated Threads Search

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old   January 10, 2013, 17:35
Default Distribution list import from excel to outlook
  #1
Super Moderator
 
diamondx's Avatar
 
Ghazlani M. Ali
Join Date: May 2011
Location: Tokyo, Japan
Posts: 1,385
Blog Entries: 23
Rep Power: 28
diamondx will become famous soon enough
Dear friends,
I have a list of e-mails in excel, around 450 e-mails.
I followed this easy tutorial, it works good : http://blogs.goucher.edu/training/20...ok-email-list/
I want to create a list of distribution. i have tried with 2 contacts, it works.

I was wondering if that can work with hundreds of e-mails. i can try it now as i don't have the final excel version (my professor has it)
__________________
Regards,
New to ICEM CFD, try this document --> https://goo.gl/KAOIwm
Ali
diamondx is offline   Reply With Quote

Old   January 10, 2013, 17:57
Default
  #2
Retired Super Moderator
 
Bruno Santos
Join Date: Mar 2009
Location: Lisbon, Portugal
Posts: 10,975
Blog Entries: 45
Rep Power: 128
wyldckat is a name known to allwyldckat is a name known to allwyldckat is a name known to allwyldckat is a name known to allwyldckat is a name known to allwyldckat is a name known to all
Greetings Ali,

Well, it should work... assuming Outlook won't crash with 450 contacts in a single line for a single email...

It basically tells you to:
  1. Copy only the lines of emails addresses from Excel;
  2. Paste without special HTML tags, i.e. just as text;
  3. Search and replace the beginning of each paragraph with a semicolon ";".
  4. Copy-paste the resulting semicolon separated list into Outlook's desired section, which I suggest BCC (Blind Carbon Copy), unless of course you're seeking to be sued by one or more of the people on the list.


The optimal solution would be to create an address book in Outlook, then associate a distribution list to all of those contacts. The following looks rather detailed, although somewhat old: http://www.informit.com/articles/article.aspx?p=417511


Have fun!
Bruno
__________________

Last edited by wyldckat; January 10, 2013 at 17:58. Reason: each paragraph, not all for a single semicolon
wyldckat is offline   Reply With Quote

Old   January 11, 2013, 10:51
Default
  #3
Super Moderator
 
diamondx's Avatar
 
Ghazlani M. Ali
Join Date: May 2011
Location: Tokyo, Japan
Posts: 1,385
Blog Entries: 23
Rep Power: 28
diamondx will become famous soon enough
i've tried it yesterday, the copy paste works. But i could not save the list as it was saying that they were too many contact. i just splitted the 440 contact into 4 list of 110 contact each. let's just hope it can send that without considering it as a spam... thanks for your link tough , apreciated
__________________
Regards,
New to ICEM CFD, try this document --> https://goo.gl/KAOIwm
Ali
diamondx is offline   Reply With Quote

Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
[swak4Foam] swak4foam building problem GGerber OpenFOAM Community Contributions 54 April 24, 2015 16:02
friction forces icoFoam ofslcm OpenFOAM 3 April 7, 2012 10:57
CFX-Pre problem, pls help!!! cth_yao CFX 0 February 17, 2012 00:52
OpenFOAM on MinGW crosscompiler hosted on Linux allenzhao OpenFOAM Installation 127 January 30, 2009 19:08
DecomposePar links against liblamso0 with OpenMPI jens_klostermann OpenFOAM Bugs 11 June 28, 2007 17:51


All times are GMT -4. The time now is 13:35.