{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Liste d’anniversaires"],"not_rendered":{"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Liste d’anniversaires","index":0,"n_rows":10,"n_cols":13,"rows_kept":10,"merged":[[0,1,0,8],[1,3,1,4],[1,10,2,10],[1,11,2,12],[1,13,2,13],[5,12,8,12]]}
[null,"   Liste d’anniversaires"]
[{"$nulls":3},"Anniversaire",{"$nulls":7},"Personnalisation de l’e-mail"]
[null,"Colonne1","Nom","Mois","Jour","Courriel","Téléphone","Notes","Envoyer un courriel"]
[null,{"$f":"IFERROR(IF(TableauAnniversaire[[#This Row],[Envoyer un courriel]]<>\"\",1,0),\"\")","v":1},"Nom 1",{"$f":"TEXT(TODAY(),\"mmm\")","v":"mai"},{"$f":"TEXT(TODAY(),\"jj\")","v":"03"},"Courriel","Téléphone","30e anniversaire",{"$f":"IFERROR(IF(CAnniversaire=TODAY(),HYPERLINK(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(BaseEmail,CHAR(10),\"%0A\"),\"[e]\",TableauAnniversaire[[#This Row],[Courriel]]),\"[n]\",TableauAnniversaire[[#This Row],[Nom]]),\"Envoyer un courriel\"),\"\"),\"\")","v":"Envoyer un courriel"},null,null,"Objet :","Joyeux anniversaire !"]
[null,{"$f":"IFERROR(IF(TableauAnniversaire[[#This Row],[Envoyer un courriel]]<>\"\",1,0),\"\")","v":0},"Nom 2","mar",28,"Courriel","Téléphone","Adore le chocolat",{"$f":"IFERROR(IF(CAnniversaire=TODAY(),HYPERLINK(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(BaseEmail,CHAR(10),\"%0A\"),\"[e]\",TableauAnniversaire[[#This Row],[Courriel]]),\"[n]\",TableauAnniversaire[[#This Row],[Nom]]),\"Envoyer un courriel\"),\"\"),\"\")","v":""},null,null,"Formule de politesse :","Salut"]
[null,{"$f":"IFERROR(IF(TableauAnniversaire[[#This Row],[Envoyer un courriel]]<>\"\",1,0),\"\")","v":0},"Nom 3","jan",23,"Courriel","Téléphone","Collectionne les anges",{"$f":"IFERROR(IF(CAnniversaire=TODAY(),HYPERLINK(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(BaseEmail,CHAR(10),\"%0A\"),\"[e]\",TableauAnniversaire[[#This Row],[Courriel]]),\"[n]\",TableauAnniversaire[[#This Row],[Nom]]),\"Envoyer un courriel\"),\"\"),\"\")","v":""},null,null,"Message :","Je te souhaite un bon anniversaire. J’aurais bien aimé pouvoir le fêter avec toi aujourd'hui !\n\nAmicalement,"]
[]
[]
[]
[{"$nulls":11},"Votre nom :","Entrez votre nom"]