Docstoc

Email

Document Sample
Email Powered By Docstoc
					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]
                  <br>
                  <br>
                  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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:132
posted:11/21/2011
language:English
pages:6