Need to inform 1000 people of a move

[Jordan]

We are moving the company and I need to send 1000 people a email stating the
new address. I have all the email addresses in an Excel spreadsheet. What
is the easiest way with Outlook or even some other program to do this?

 

[Oliver Vukovics]

Hi Jordan,

you could do it with Outlook and Word.

This way only works if you have the same Outlook and Word version.

Maybe this helps:
http://support.microsoft.com/kb/294694/en-us
http://support.microsoft.com/kb/304862/en-us

 

[John Blessing]

Hi Jordan,

Assuming all of the e-mail addresses are in a column or row, just
highlight
all 1000 cells, press CTRL-C, switch to Outlook, and in the To... line hit
CTRL-V, though I would suggest using the BCC line instead to prevent all
recipients from seeing all 1000 addresses (you can see BCC through the
Options button, and you need to specify at least one address in the To...
line, such as your own). You will notice that after you paste the
addresses,
they will be separated by semicolons and underlined.

There are of course more elegant methods, such as creating a distribution
list, importing the spreadsheet to Outlook contacts, ect. But for just one
mailing, this method will be quick and simple.
--

Except that most smtp servers restrict the max number of recipients of an
email, typically <100.

Mailmerge is the way to go or please try our email scheduler
(http://www.lbetoolbox.com/scheduleemail.htm) which will allow you to send
multiple individual emails, either as a one-off or regularly at a specified
time and interval.

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters

 

[Sanjay Singh]

You can follow the instructions to copy the e-mails to the To field given
earlier and then use something like PersonalizedEmails to create separate
e-mails to each person to get around the 100 user limitation.
http://www.addins4outlook.com/personalizedemails

 

[Oliver Vukovics]

Hi Jordan,

import the Excel spreadsheet into Outlook and send a serial mail with
Outlook and Word:
http://support.microsoft.com/kb/192258/en-us
http://support.microsoft.com/kb/304862/en-us

One of the description is for Outlook 2000 but it is nearly the same in
Outlook 2003

May it helps.

 

[Sue Mosher [MVP-Outlook]]

Why import? Why not just use the worksheet data in a Word mail merge?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers