Generate the 2025 End-of-Year emails for all 11 Bon Secours / Mercy Health markets from one copy doc. The builder swaps in each market’s merge-field values and tracking URL automatically. No coding required.
You will need two files:
.xlsx) — one Final URL per market & email. Every link and button in an email uses that single URL; the Make my Gift Monthly button automatically gets &isMonthly=true appended.markets[] in CLIENT_CONFIG.js..zip file will be saved to your Downloads folder..zip → Extract All… → click Extract..zip file. A folder will appear beside it..html file — this is the file the builder needs..html file into the drop-google-doc-html-here folder inside the builder folder. This makes it easy to find later, but it is not required — you can drag the file from anywhere.index.html. It will open in your default web browser..html from Step 1 onto the “Google Docs HTML” drop zone (or click to browse)..xlsx onto the second drop zone.Both files are required. The builder will process them and take you to the review screen.
The review screen has several areas:
Click the Preview button in the top-right corner of the toolbar. A live preview panel will open to the right of the editor, showing you what the email looks like with full branding — header, body content, footer, and social links.
At the bottom of the screen you will find these action buttons:
.html file.BonSecours_EOY_<MARKET>_Email<N>.html.Click New Build in the bottom-right corner to clear everything and return to the upload screen. You can then drop in a new document and start fresh.
| Problem | Solution |
|---|---|
| “No emails found” error after generating | Make sure the Google Doc uses headings formatted as “Email #1”, “Email #2”, etc. The builder looks for this pattern to identify each email. |
You see {need UTM} in the HTML |
This means no UTM spreadsheet was provided. Either upload the UTM spreadsheet and regenerate, or manually replace these placeholders with the correct tracking URLs. |
| Preview panel looks blank or bare | Make sure you scroll down inside the preview — the email body, footer, and social icons may be below the visible area. |
| The drop zone does not accept the file | Confirm the file has an .html or .htm extension (for the first zone) or .xlsx / .csv (for the UTM zone). If you downloaded the Google Doc as a .zip, make sure you extracted/unzipped it first. |
| Some emails show fewer segments than expected | The builder detects segments from the color-coded segmentation keys in the copy document. If a segment is missing, check that the Google Doc has the correct highlight colors for that email’s segmentation table. |
| Forward (FWD) emails look incomplete | FWD emails automatically stitch in the body from the base email they reference. If the base email is missing or has a different number, the FWD may appear incomplete. Check that both the FWD and base emails are in the document. |