{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Start Here","Bulk e-mail drafts","E-mail details"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start Here","index":0,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Bulk E-mail Draft Generator (Excel + Outlook)"]
[]
["WHAT THIS DOES"]
["Creates up to 10 Outlook e-mail drafts at a time, each with:"]
["·         unique recipient"]
["·         subject line"]
["·         optional attachment"]
[]
["E-mails open as drafts - nothing is sent automatically."]
[]
["REQUIREMENTS"]
["·         Microsoft Excel (desktop)"]
["·         Microsoft Outlook (desktop)"]
["·         Windows"]
["·         Macros must be enabled"]
["·         When opening the file, you may need to click \"Enable Editing\" and \"Enable Content\"."]
[]
["FREE VERSION LIMIT"]
["This free version is limited to 10 e-mails at a time."]
[]
["HOW TO USE"]
["1.     Complete the \"E-mail details\" sheet"]
["2.     Fill rows 2-11 on \"Bulk e-mail drafts\""]
["3.     Click \"Prepare draft e-mails\" button"]
["4.     Review drafts on screen / in Outlook before sending"]
[]
["Prefer not to deal with spreadsheets at all?"]
["Simple Books offers fixed-price monthly bookkeeping."]
[]
[]
[]
["Notes"]
["This tool creates Outlook e-mail drafts only - nothing is sent automatically."]
["Please review all e-mails and attachments before sending."]
["Use of this spreadsheet is at your own discretion."]

{"sheet":"Bulk e-mail drafts","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["To","CC","Subject","Attachment (full file path)"]
["Aaron.Beaumont@ABIndustries.com","Finance@ABIndustries.com","Remittance advice - AB Industries","C:\\Users\\jbloggs\\Desktop\\Remittance 1.pdf","Free version allows up to 10 rows (2-11)"]
["CarolWayne@WayneEnterprises.co.uk",null,"Remittance advice - Wayne Enterprises","C:\\Users\\jbloggs\\Desktop\\Remittance 2.pdf"]
["Fiona.Jenkins@OceanicPackaging.co.uk",null,"Remittance advice - Oceanic Packaging","C:\\Users\\jbloggs\\Desktop\\Remittance 3.pdf"]
["accounts@ACCFabrications.co.uk",null,"Remittance advice - ACC Fabrications","C:\\Users\\jbloggs\\Desktop\\Remittance 4.pdf"]
["StephanieYates@quickrecruit.co.uk","SimonMeakin@quickrecruit.co.uk","Remittance advice - Quick Recruit","C:\\Users\\jbloggs\\Desktop\\Remittance 5.pdf"]
["AJames@Gsupplies.com",null,"Remittance advice - Gamma Supplies","C:\\Users\\jbloggs\\Desktop\\Remittance 6.pdf"]
["PeterBenn@SureWrite.co.uk","Accounts@SureWrite.co.uk","Remittance advice - SureWrite Stationery","C:\\Users\\jbloggs\\Desktop\\Remittance 7.pdf"]
["AR@Prestige.com",null,"Remittance advice - Prestige Accounting","C:\\Users\\jbloggs\\Desktop\\Remittance 8.pdf"]
["AnekPatel@CapitalLogistics.co.uk","AnujPatel@CapitalLogistics.co.uk","Remittance advice - Capital Logistics","C:\\Users\\jbloggs\\Desktop\\Remittance 9.pdf"]
["enquiries@pitstopfood.co.uk",null,"Remittance advice - Pit Stop Food","C:\\Users\\jbloggs\\Desktop\\Remittance 10.pdf"]

{"sheet":"E-mail details","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["E-mail details"]
["From:","JBloggs@OurCompany.co.uk"]
["On behalf of:","Accounts@OurCompany.co.uk"]
["Body:","Good morning,"]
[null,"Please see attached remittance advice in respect of our recent payment."]
[null,"Kind regards,"]