View original (French)

Problème de publipostage format du mois d'août

plm2222 Posted messages 7 Status Member -  
Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   -
Hello,
Hello, does anyone know why the month of August is not displayed correctly in the mail merge ...
Thank you

"Saturday, Août 13, 2016" instead of "Saturday 13 August 2016".
The format is of this type: MERGEFIELD "Date_Fin" \@ "DDDD dd MMMM yyyy"

I specify that for all other months of the year, it works well ...

Thanks in advance
phil

6 answers

  1.
    Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Re,

    if you enter 14/03/2012 and your cell displays Wednesday 14 March 2012, it means you have formatted your cell(s) with a custom format like dddd dd mmmm yyyy
    to return to your mail merge, if you want your merge field to maintain this format, for example Wednesday 14 March 2012, I advise you to create a column in your database that will keep your dates in the entry format 14/03/2012 and transform them into text format Wednesday 14 March 2012

    for example, if your dates are in column B and start in B2, in the created column enter this formula 
    =TEXT(B2;"dddd dd mmmm yyyy")


    and you replace the current merge field in your template letter with the newly created column

    A+
    Mike-31

    A period of failure is a perfect time to sow the seeds of knowledge.
    2
  2. jeanbern Posted messages 13740 Registration date   Status Contributor Last intervention   5 136
     
    Hi,
    ask C-Clair: https://forums.commentcamarche.net/profile/user/C%2DClaire
    she is knowledgeable about Word

    --
    Thanks to everyone
    0
    1. C-Claire Posted messages 4562 Registration date   Status Member Last intervention   2 250
       
      Hello jeanbern,

      thank you, it's too much of an honor ;-)

      C-Claire
      0
      1. jeanbern Posted messages 13740 Registration date   Status Contributor Last intervention   5 136 > C-Claire Posted messages 4562 Registration date   Status Member Last intervention  
         
        Hi,
        Usually I direct people to competent individuals and you seem really professional at least with Word!!!
        I saw it with the E in superscript (do you remember?)

        ;-))
        0
      2. C-Claire Posted messages 4562 Registration date   Status Member Last intervention   2 250 > jeanbern Posted messages 13740 Registration date   Status Contributor Last intervention  
         
        Ah, Jeanbern! I knew I had seen you somewhere ;-)
        There are a few super pros here, a bit rarer at the moment (probably because of the holidays) and a great new generation that I have been discovering for some time.

        See you soon,

        C-Claire
        0
  3. C-Claire Posted messages 4562 Registration date   Status Member Last intervention   2 250
     
    Hello Phil,

    August is the only month with a circumflex accent. And it's that û that is replaced by "whatever."

    To try to help you, tell us what your data source is: Excel? Word? Access? Other? And what technique you are using for the mail merge. The version of Word may also be useful as well as the language of the interface.

    Or, you could remove the accent from the source, but that would make me shudder ;-)

    C-Claire
    0
  4. plm2222 Posted messages 7 Status Member
     
    Hello and thank you!
    My source is Excel in long date format (so there is indeed a circumflex accent)
    For the technique, I am using the standard mail merge tool in Word.
    The worst part is that not only does Word not force the format (Saturday, August 9, 2017) (MERGEFIELD "Date_Fin" \@ "DDDD dd MMMM yyyy"
    ) like all the others, but it remains in the format "Wednesday, Août 09, 2017"

    It’s crazy!!
    Phil

    Please note, I’m on Mac.
    0
    1. C-Claire Posted messages 4562 Registration date   Status Member Last intervention   2 250
       
      Ouch... I'm not "tied down" but on PC, a way to solve this problem is to do the mail merge using the DDE exchange protocol.

      Edit: The DDE protocol doesn't seem to be offered on Word Mac.
      If not, a workaround would be to create an additional column in your Excel file and copy/paste the formatted date results there.

      Not great, but nothing better until help arrives.

      C-Claire
      0
  6. plm2222 Posted messages 7 Status Member
     
    Thank you very much, but it doesn't work!!
    Phil
    0
  7. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Good evening everyone,

    how did you enter your dates into your database, with a formula like =today() or did you input your date like 01/08/2016 and format it as
    01 August 2016 or directly entered 01 August 2016, etc...

    See you later
    Mike-31

    A period of failure is a perfect time to sow the seeds of knowledge.
    0
    1. plm2222 Posted messages 7 Status Member
       
      Hello Mike-31, I'm coming back on 14/03/2012 and I have the date format "Wednesday, March 14, 2012"
      Best regards
      Phil
      0