{"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","E-mail","Téléphone","Notes","Envoyer un e-mail"]
[null,{"$f":"IFERROR(IF(TableauAnniversaire[[#This Row],[Envoyer un e-mail]]<>\"\",1,0),\"\")","v":1},"Nom 1",{"$f":"TEXT(TODAY(),\"mmm\")","v":"avr"},{"$f":"TEXT(TODAY(),\"jj\")","v":"23"},"E-mail","Téléphone","30e anniversaire",{"$f":"IFERROR(IF(CAnniversaire=TODAY(),HYPERLINK(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(BaseEmail,CHAR(10),\"%0A\"),\"[e]\",TableauAnniversaire[[#This Row],[E-mail]]),\"[n]\",TableauAnniversaire[[#This Row],[Nom]]),\"envoyer un e-mail\"),\"\"),\"\")","v":"envoyer un e-mail"},null,null,"Objet :","Joyeux anniversaire !"]
[null,{"$f":"IFERROR(IF(TableauAnniversaire[[#This Row],[Envoyer un e-mail]]<>\"\",1,0),\"\")","v":0},"Nom 2","mar",28,"E-mail","Téléphone","Adore le chocolat",{"$f":"IFERROR(IF(CAnniversaire=TODAY(),HYPERLINK(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(BaseEmail,CHAR(10),\"%0A\"),\"[e]\",TableauAnniversaire[[#This Row],[E-mail]]),\"[n]\",TableauAnniversaire[[#This Row],[Nom]]),\"envoyer un e-mail\"),\"\"),\"\")","v":""},null,null,"Formule de politesse :","Salut"]
[null,{"$f":"IFERROR(IF(TableauAnniversaire[[#This Row],[Envoyer un e-mail]]<>\"\",1,0),\"\")","v":0},"Nom 3","jan",23,"E-mail","Téléphone","Collectionne les anges",{"$f":"IFERROR(IF(CAnniversaire=TODAY(),HYPERLINK(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(BaseEmail,CHAR(10),\"%0A\"),\"[e]\",TableauAnniversaire[[#This Row],[E-mail]]),\"[n]\",TableauAnniversaire[[#This Row],[Nom]]),\"envoyer un e-mail\"),\"\"),\"\")","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"]