View original (French)

Create an email list from Excel

Solved
melesse35 -  
pelo47 Posted messages 13 Status Member -
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 answers

  1.
    UsulArrakis Posted messages 7683 Status Contributor 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
    1. melesse35
       
      What is CSV?
      Thank you
      0
    2. 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