{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Birthday List"],"not_rendered":{"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Birthday List","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,"   Birthday list"]
[{"$nulls":3},"Birthday",{"$nulls":7},"Email customisation"]
[null,"Column1","Name","Month","Day","Email Address","Phone Number","Notes","Send email"]
[null,{"$f":"IFERROR(IF(BirthdayTable[[#This Row],[Send email]]<>\"\",1,0),\"\")","v":1},"Name 1",{"$f":"TEXT(TODAY(),\"mmm\")","v":"Apr"},{"$f":"TEXT(TODAY(),\"dd\")","v":"24"},"Email Address","Phone Number","30th Birthday",{"$f":"IFERROR(IF(CBirthday=TODAY(),HYPERLINK(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(EmailBase,CHAR(10),\"%0A\"),\"[e]\",BirthdayTable[[#This Row],[Email Address]]),\"[n]\",BirthdayTable[[#This Row],[Name]]),\"send email\"),\"\"),\"\")","v":"send email"},null,null,"Subject:","Happy Birthday!"]
[null,{"$f":"IFERROR(IF(BirthdayTable[[#This Row],[Send email]]<>\"\",1,0),\"\")","v":0},"Name 2","Mar",28,"Email Address","Phone Number","Loves chocolate",{"$f":"IFERROR(IF(CBirthday=TODAY(),HYPERLINK(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(EmailBase,CHAR(10),\"%0A\"),\"[e]\",BirthdayTable[[#This Row],[Email Address]]),\"[n]\",BirthdayTable[[#This Row],[Name]]),\"send email\"),\"\"),\"\")","v":""},null,null,"Salutation:","Hi"]
[null,{"$f":"IFERROR(IF(BirthdayTable[[#This Row],[Send email]]<>\"\",1,0),\"\")","v":0},"Name 3","Jan",23,"Email Address","Phone Number","Collects angels",{"$f":"IFERROR(IF(CBirthday=TODAY(),HYPERLINK(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(EmailBase,CHAR(10),\"%0A\"),\"[e]\",BirthdayTable[[#This Row],[Email Address]]),\"[n]\",BirthdayTable[[#This Row],[Name]]),\"send email\"),\"\"),\"\")","v":""},null,null,"Message:","Hoping you have a great birthday and wishing we could be together today!\n\nFrom"]
[]
[]
[]
[{"$nulls":11},"Your Name:","Enter your name"]