Mailing: choose your header line

INEEDYOUPLZ Posted messages 2 Status Member -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   -
Hello everyone,

I am currently working on Excel spreadsheets to carry out mail merges, and I am facing a problem that I have not yet found answers to.

Indeed, I would like the third row in Excel to be my reference for my headers during the mail merge.

When I start the mail merge, Word automatically uses the first row as the reference for my lists.

Could you explain to me as if you were explaining it to a 10-year-old?

Thank you very much in advance for your answers.

2 answers

  1. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    Yes, gladly! As soon as we receive your two files ...
     1) Go to https://www.cjoint.com/ 
    2) Click on [Browse] to select your file (15 MB max)
    3) Scroll down to click the blue button [Create Cjoint link]
    4) After a few seconds, the second page will appear, with the link in bold; right-click on it and choose "Copy link"
    5) Go back to your discussion on CCM, and in your message, paste it.
    =>See the guide https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers
    There is also:
    1) https://mon-partage.fr/
    2) https://www.transfernow.net/


    --
    It's nice, retirement! Especially in the Antilles ...
    Raymond (INSA, AFPA)
    0
    1. INEEDYOUPLZ Posted messages 2 Status Member
       
      Hello Raymond! Thanks for your response!

      As requested:
      Here is the link to my EXCEL database: https://www.cjoint.com/c/ILcsR2mzwHM
      Here is the link to my WORD document: https://www.cjoint.com/c/ILcsWa2FZHM

      This is not the database I will be working on (unfortunately, I can't share it on the forum...)

      The green information in the EXCEL database corresponds to the row I want to use as headers, not the row containing "concerned establishment" and "update date" as WORD would suggest...)

      How to proceed...?
      0
  2. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    I think I'm going to stop here!
    The Word file is blank... The Excel file cannot be opened...

    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0