ReportsDNA
This workbook provides examples of ReportsDNA's email features.
Worksheet Description Type
Overview Outlines this workbooks purpose and contents.
Email worksheet as attachment Automatically sends the report (worksheet, not the workbook) as an Report
attachment to the same email recipients each time the report is generated.
Email report content in body Generates an email preview (does not send it automatically) with the report in Report
the body of the email in HTML format to the same email recipients each time
the report is generated.
Email to Dynamic Recipients Generates an email preview (does not send it automatically) with the report in Report
the body of the email in HTML format to the email addresses in the Email field
of the data. It also attaches the entire workbook to the email.
Removes bad email addresses Automatically sends an email with the report in the body of the email in HTML Report
format to the email addresses in th Email field of the data. It removes any
email addresses that are not resolveable (bad addresses).
Data Data
EXAMPLE REPORT
Automatically sends the report (worksheet, not the
workbook) as an attachment to the same email recipients
ORIGINAL DATASET
First Name Last Name Order Email
Jane Doe Milk janedoe@nomail.abc
John Doe Eggs johndoe@nomail.abc
Doe Smith Milk doesmith@nomail.abc
Jane Doe Butter
REPORT SETTINGS
Email After Send
Generate
Report Attachment
Email Format HTML
Attach worksheet
Suppress Page unchecked
Breaks
Remove Bad Off
Addresses
TO myself@nomail.abc
CC myboss@nomail.abc
BCC
Subject My First Emailed Report: &[RecordCount] records as of &[DATE]
Body Please see attached report.
REPORT OUTPUT
First Name Last Name Order Email
Jane Doe Milk janedoe@nomail.abc
John Doe Eggs johndoe@nomail.abc
Doe Smith Milk doesmith@nomail.abc
Jane Doe Butter
2 of 6 Generated by TheScripter.com
EXAMPLE REPORT
Generates an email preview (does not send it automatically)
with the report in the body of the email in HTML format to
the same email recipients each time the report is generated.
ORIGINAL DATASET
First Name Last Name Order Email
Jane Doe Milk janedoe@nomail.abc
John Doe Eggs johndoe@nomail.abc
Doe Smith Milk doesmith@nomail.abc
Jane Doe Butter
REPORT SETTINGS
Email After Preview
Generate
Report Body
Email Format HTML
Attach n/a
Suppress Page unchecked
Breaks
Remove Bad Off
Addresses
TO myself@nomail.abc
CC myboss@nomail.abc
BCC
Subject My First Emailed Report: &[RecordCount] records as of &[DATE]
Body &[Report]
REPORT OUTPUT
First Name Last Name Order Email
Jane Doe Milk janedoe@nomail.abc
John Doe Eggs johndoe@nomail.abc
Doe Smith Milk doesmith@nomail.abc
Jane Doe Butter
3 of 6 Generated by TheScripter.com
EXAMPLE REPORT
Generates an email preview (does not send it automatically)
with the report in the body of the email in HTML format to
the email addresses in the Email field of the data. It also
attaches the entire workbook to the email.
ORIGINAL DATASET
First Name Last Name Order Email
Jane Doe Milk janedoe@nomail.abc
John Doe Eggs johndoe@nomail.abc
Doe Smith Milk doesmith@nomail.abc
Jane Doe Butter
REPORT SETTINGS
Email After Preview
Generate
Report Body & Attachment
Email Format HTML
Attach workbook
Suppress Page unchecked
Breaks
Remove Bad Off
Addresses
TO &F[Email]
CC
BCC
Subject My First Emailed Report: &[RecordCount] records as of &[DATE]
Body Please see attached report.
REPORT OUTPUT
First Name Last Name Order Email
Jane Doe Milk janedoe@nomail.abc
John Doe Eggs johndoe@nomail.abc
Doe Smith Milk doesmith@nomail.abc
Jane Doe Butter
4 of 6 Generated by TheScripter.com
EXAMPLE REPORT
Generates an email preview with the report in the body of the
email in HTML format to the email addresses in th Email field
of the data. It removes any email addresses that are not
resolveable (bad addresses).
ORIGINAL DATASET
First Name Last Name Order Email
Jane Doe Milk janedoe@nomail.abc
John Doe Eggs johndoe@nomail.abc
Doe Smith Milk doesmith@nomail.abc
Jane Doe Butter
REPORT SETTINGS
Email After Preview
Generate
Report Body
Email Format HTML
Attach n/a
Suppress Page unchecked
Breaks
Remove Bad On
Addresses
TO myself@nomail.abc;&F[Email]
CC badaddress
BCC
Subject My First Emailed Report: &[RecordCount] records as of &[DATE]
Body &[Report]
This email was not sent to the following recipients:
[BADRECIPIENTS]
REPORT OUTPUT
First Name Last Name Order Email
Jane Doe Milk janedoe@nomail.abc
John Doe Eggs johndoe@nomail.abc
Doe Smith Milk doesmith@nomail.abc
Jane Doe Butter
5 of 6 Generated by TheScripter.com
First Name Last NameOrder Email
Jane Doe Milk janedoe@nomail.abc
John Doe Eggs johndoe@nomail.abc
Doe Smith Milk doesmith@nomail.abc
Jane Doe Butter