Email Support

[YodaMan]

I have a contact list within Excel. At times I need to send a mass email to all the email addresses at once. I use Outlook so they need to be separated by a semi-colon. Well I can easily do that by replacing all the .com with .com;
The only thing is that its in a listed format and when I cut and paste them into the "To" line, only the first one carries over.
Any suggestions?

Any other possible solutions that anyone can suggest?

 

[KGB]

You can take a copy of your Excel sheet and convert it to an Access database.
Then import the database into Outlook.
The key is making sure the fields are mapped correctly.

 

[YodaMan]

I dont have access :frown:

 

[YodaMan]

Ok I found a computer here with Access. As you can probably guess I have never used it before. Any clues/suggestions as to how I can covert my column in Excel to separate email addresses that can be imported into Outlook?

Thanks in advance!

 

[Geniere]

I would save your Excel file as a text(txt) file, than open the file with Word. Use the editing functions in the word processor to format the addresses. If you know how to write Excel macros, it is easily done that way.

 

[YodaMan]

I have a list of over 600. The reason I am trying to do this is so that it can be done anytime because doing it that way will take me hours. Thanks though.