View original (French)

Create an email list from Excel

Solved
melesse35 -  
pelo47 Posted messages 13 Status Membre -
Hello,

I would like to know how to retrieve all email addresses from an Excel database and "copy, paste" them with a semicolon between each email address for sending a mailing.

Each email address is in a different cell in Excel.

Thank you for your help.

Configuration: Windows XP / Internet Explorer 6.0

8 réponses

Réponse 1 / 8
UsulArrakis Posted messages 7683 Status Contributeur 3 196
 
good
I may have found it
same method with CSV and TXT
but when you paste your range of cells into a new file you do a special paste / transpose then CSV then TXT ...
--

(_Usul of Arrakis
Serial_Dreamer_)
17
melesse35
 
What is CSV?
Thank you
0
melesse35
 
Here it is, it's working! For those interested, here’s the solution:
In the Excel extraction file, copy the entire column with the emails into a Word document. At the bottom of the paste, click on the small square and select “keep text only.”

Press ctrl + H, a box will appear. Click on the “More” button with the little arrows to expand the box. Place the cursor in the “Find what” box + click on Special and select paragraph mark. Place the cursor in the “Replace with” box and type a semicolon. Click on “Replace All.” All line breaks will be replaced by a semicolon. Then just copy all the emails and paste them into the email in Bcc.

Thanks to UsulArrakis for the excellent advice and to Michel (the macro worked but it was a bit of a hassle because you had to do the process several times).

Hi everyone.
11