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

Distribution list import from excel to outlook

Register Blogs Members List Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools Display Modes
Old   January 10, 2013, 18:35
Default Distribution list import from excel to outlook
  #1
Super Moderator
 
diamondx's Avatar
 
Ghazlani M. Ali
Join Date: May 2011
Location: Canada
Posts: 1,290
Blog Entries: 23
Rep Power: 20
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 --> http://goo.gl/G2gkE
Ali
diamondx is offline   Reply With Quote

Old   January 10, 2013, 18:57
Default
  #2
Super Moderator
 
Bruno Santos
Join Date: Mar 2009
Location: Lisbon, Portugal
Posts: 8,117
Blog Entries: 34
Rep Power: 83
wyldckat is just really nicewyldckat is just really nicewyldckat is just really nicewyldckat is just really nice
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 18:58. Reason: each paragraph, not all for a single semicolon
wyldckat is offline   Reply With Quote

Old   January 11, 2013, 11:51
Default
  #3
Super Moderator
 
diamondx's Avatar
 
Ghazlani M. Ali
Join Date: May 2011
Location: Canada
Posts: 1,290
Blog Entries: 23
Rep Power: 20
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 --> http://goo.gl/G2gkE
Ali
diamondx is offline   Reply With Quote

Reply

Thread Tools
Display Modes

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 On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
swak4foam building problem GGerber OpenFOAM Installation 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 01:52
OpenFOAM on MinGW crosscompiler hosted on Linux allenzhao OpenFOAM Installation 127 January 30, 2009 20: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 23:45.