Send mail to list of contacts 2

[flaviooooo]

Hi,

with the holidays coming up, we would like to send a greetings card to our customers.

We have listed all emailadresses in an Excellist, but now we are wondering if it is possible to add all these adresses into the 'TO'-field of the mail in 1 clean swoop?

Can this be done without programming etc?

Kind regards

 

[kjv1611]

You could import the list of contacts (assuming the same format throughout) into Outlook, and when you do so, include them all in the same address book.

Then, create a distribution list with all of the names in it, so you don't have to redo your email message each time.

Otherwise, I would guess you'd have to do with by doing some programming, or using some already written code, or possibly buying another program.

 

[hext2003]

Sorry I don't have an answer but just a thought. If you send out an email through a distribution list, won't every one see who all your other customers are? or don't you care if they see?

 

[arthurbr]

If you put them in the Bcc field, noone can see the e-mail adresses

 

[Craino]

Just click on the column header to highlight the entire column, then copy out of excel and paste into the appropriate to:, cc:, or bcc: box in Outlook. I've done this before and Outlook will resolve the cells no problem.

 

[flaviooooo]

Hey,

unfortunately we use the dreaded Lotus Notes at work, so I don't know how that will react...

I will test it out on Monday and let you guys know.

Thanks for the responses!

 

[kjv1611]

Ok, Craino, I have definitely got to give you a star for that. That is just too cool! I would never have guessed of just copying and pasting cells with email addresses to Outlook! Way cool! Here's a purple thing!

 

[ThePumpkin]

Hi

If your email can't cope with pasting the cells. I do as Craino suggested but copy the cells into Word first, convert the table to text (Table > Convert > Table to text) - each email address appears on a separte line with no cells. Then copy and paste that list into the TO/CC/BCC field.

Cheers
Karen

 

[flaviooooo]

Hey guys,

Lotus Notes was also able to resolve the cells from excel directly, perfect!

Have a star from me.