Copyright: © FMS, Inc.


Welcome!

Welcome to Total Access Emailer. Total Access Emailer leverages the power of Microsoft Access and email so you can generate personalized email for everyone in your Access tables or queries.

This Help File contains the information that you need to get the most out of Total Access Emailer.

Important Topics

•	About Total Access Emailer

•	Installing an SMTP Server

•	Installing the Program

•	Starting Total Access Emailer

•	Email Blast Overview

•	Advanced Customization

•	Launching the Email Blast

•	Programmatic Interface

•	Support Resources

•	License Agreement


About Total Access Emailer

Microsoft Access is the most popular database program in the world. It achieved its success by solving a wide range of database problems quickly and cost efficiently. Most organizations use Access databases to store contact information, including email addresses, for customers, clients, prospects, employees, and more.

Until now, leveraging this data to communicate with your contacts has been difficult and inefficient. Total Access Emailer makes it simple by letting you generate personalized email messages for contacts stored in your tables. Send messages in Text or HTML format, attach files, embed Access objects, and use field values to create unique, personalized emails for each recipient. You can even maintain audit trails to track who was contacted, when they were emailed, and what they received.

Designed Exclusively for Microsoft Access

Total Access Emailer is designed specifically for Access and has an intuitive, easy-to-use interface. Tightly integrated into Access, it runs as an add-in and includes an interactive, Wizard-like user interface, making it easy to customize your email blasts right in Access.

Choose any table or query in your database, specify the email field, and you’re ready to contact everyone in your list. You can use field references to send personalized emails, and even attach files and embed Access tables, queries/views, and reports.

Your email blast settings are automatically saved in your database for reuse and sharing with other users.

	For optimal performance, your databases should be regularly compacted and backed up. If you do not have an automated process in place, consider Total Visual Agent from FMS, which automates these administrative chores. For more information and a demo, visit www.fmsinc.com.
See Also:

•	Program Highlights

•	New Features in Version X.5

•	Visit our Web Site


Program Highlights

Unlimited Custom Emails

•	Send Email to Everyone
Easily send email to a list of email addresses from a table or query. Emails can be sent individually or in bulk using Cc or Bcc.

•	Personalize Email
Customize the email subject and message for each recipient by referencing field values from your table or query. You can even specify a field in your data containing the subject and message, giving you complete control over each message.

•	Embed Access Objects
Embed tables, queries/views, and reports in your email message, or as attachments. Leave the data unfiltered to send every recipient the same data, or filter it so it’s customized for each recipient (e.g., send recipients only their own invoices). With this feature, you can use Access reports to create custom HTML messages for each recipient.

•	Send Your Email Again
Email blast settings are automatically saved for reuse— send the email again, or edit it with your latest message.

•	Send to People You Have Not Emailed
An optional audit trail can be maintained to track when you sent an email to each person. Easily send the same email to new people or those whom the original message skipped because the process was interrupted.

•	Send HTML and/or Text Messages
Send your email in HTML or text format. You can even determine which method to use for individual recipients based on a field in your table.

•	Easily Add Attachments
Easily attach files and embed Access tables, queries/views, and reports as attachments. Use the same attachment for everyone, or customize attachments for each message.

•	Show Custom FROM Address
Specify the FROM address for your emails. Use the same for every email or reference a field from the data source.

Management Features Guarantee Success

•	Preview Messages
Before you send your email blast, preview your messages by sending them to a table, the screen, or an email address you specify. You can test with your entire list or specify a limited number of email addresses.

•	Schedule Email Blasts
Easily schedule your email blast to run at a later time. This is ideal if you want to send messages after hours when your mail server is less busy.

•	Send Multiple Email Blasts
Send multiple email blasts one after another. Use this feature if you have email blasts that need to go out consecutively, or if you use multiple data sources for related email blasts.

Avoid Outlook Automation Problems

To prevent email viruses, Outlook makes it practically impossible to send multiple emails programmatically. You may even have to manually confirm each message individually.

Total Access Emailer avoids this problem by using SMTP rather than Outlook. SMTP is fast and efficient, and it even allows you to specify the FROM email address of your messages, which can be different from your Outlook address.

Programmatic Features

With the purchase of the Runtime License, a Programmatic Interface is available for Access developers to add email blasts into their applications. Give your users the power of sending custom emails at the touch of a button with royalty-free runtime distribution rights!

See Also:

•	About Total Access Emailer

•	New Features in Version X.5

•	Visit our Web Site


What's New in Version X.5
New Features in Version X.5

The first version of Total Access Emailer was released in July 2003 to wide acclaim. Versions for Access 97, 2000, 2002, and 2003 were shipped. Version X.5 is now available for all of these versions (versions 8.5, 9.5, 10.5, and 11.5 for Access versions 97, 2000, 2002/XP, and 2003 respectively).

Version X.5 includes these enhancements:

Embed Filtered Access Objects

Tables, queries/views, and reports can now be embedded directly in your email messages and attachments. Easily filter the data so each recipient receives their own information based on fields in your data source.

The simplest result is using data from a table or query to send each person their set of records like a list of invoices, tasks, etc.

The most powerful feature is using the Access report generator to create sophisticated HTML messages. Any Access report you create can be exported to HTML, which you can now filter and email to each recipient. Leverage the power of Access reports to create emails that are nicely formatted with complex data, lots of detail rows, groupings, summaries, and even subreports.

Embed Graphics in HTML Messages

HTML messages automatically embed local graphics referenced by the message. You no longer need to add the graphics as attachments—they are automatically embedded in the email message.

Secure Socket Layer (SSL) Email Support

Total Access Emailer now supports sending emails through servers that require a secure or encrypted connection, using Secure Socket Layer (SSL). This provides an extra level of security, and additional support for users who exclusively use SSL mail servers. SSL support is provided in addition to SMTP and ESMTP support, which has been provided since the initial release.

Replica Database Support

Total Access Emailer now supports sending emails through Replica databases, in addition to standard MDBs and ADPs.

Email Settings Report

Total Access Emailer includes a new report to print the specifications of an email blast. The Email Blast report is available from the Report button on the Main Menu.

Backward Compatible

All email blasts created in earlier versions of Total Access Emailer work with version X.5. The new version adds one new table, usysTEmailerEmbedded, which contains the new embedded object settings. Older versions of Total Access Emailer can also run the new version’s email blasts, if the new features are not selected.

Runtime Version Available Separately

Earlier versions bundled the end user and runtime components together. Version X.5 can now be purchased as Standard Version or the Professional Version. The Standard Version is designed for end users. The Professional Version includes the Standard Version, plus a programmatic interface and Runtime License to distribute applications that use Total Access Emailer blasts to users who do not own Total Access Emailer.

See Also:

•	About Total Access Emailer

•	Program Highlights

•	Visit our Web Site


Visit our Web Site

FMS is constantly developing new and better developer solutions. Total Access Emailer is part of our complete line of products designed specifically for the Access developer. Please take a moment to visit us online at www.fmsinc.com to find out about new products and updates.

Product Announcements and Press Releases

Read the latest information on new products, new versions, and future products. Press releases are available the same day they are sent to the press. Sign up in our Feedback section to have press releases automatically sent to you via email.

Product Descriptions and Demos

Detailed descriptions for all of our products are available. Each product has its own page with information about features and capabilities. Demo versions for most of our products are also available.

Product Registration

Register your copy of Total Access Emailer online. Be sure to select the email notification option so you can be contacted when updates are available or news is released. You must be registered to receive technical support.

Product Updates

FMS is committed to quality software. When we find problems in our products, we fix them and post the new builds on our web site. Check our Product Updates page in the Technical Support area for the latest build, or see Using the Update Wizard for information on how to check for the availability of updates.

Utilities and Free Software

Download free demos and utilities, including add-ins and developer tools.

Technical Papers

FMS personnel often speak at conferences and write magazine articles, papers, and books. Copies and portions of this information are available to you online. Learn about our latest ideas and tricks for developing more effectively.

Newsgroups

Share your experiences, learn from others, and ask your questions in our virtual community. Visit our newsgroups at www.fmsinc.com/support/newsgrp.htm or see our web site for additional instructions.

Links to Other Development Sites

Jump to other locations, including newsgroups, user groups, and other sites with news, techniques, and related services.

See Also:

•	About Total Access Emailer

•	Program Highlights

•	New Features in Version X.5


Versions Available

A version of Total Access Emailer is available for each of these Microsoft Access versions:

•	Version 8.50 for Access 97

•	Version 9.50 for Access 2000

•	Version 10.50 for Access 2002

•	Version 11.50 for Access 2003

Each version only works with its version of Access.

Standard vs. Professional Version

Total Access Emailer is available in two versions. The Standard Version is for end users that do not need the programmatic interface or redistribution rights. It includes all the interactive features of Total Access Emailer.

The Professional Version includes the Standard Version, plus a programmatic interface to allow power users and developers to programmatically add email blasts to their applications (for instance, a button that launches an email blast or a system that continuously checks for certain criteria before triggering an email blast). This version also includes a royalty-free Runtime License that allows the distribution of applications with the programmatic interface to send emails to people who do not own Total Access Emailer. Complete details of the Runtime License are included in the License Agreement.

See Also:

•	System Requirements

•	Installing an SMTP Server

•	Installing the Program

•	Using the Update Wizard

•	Uninstalling the Program


System Requirements

Total Access Emailer has the following system requirements:

•	Microsoft Access
(You must have the version of Access that corresponds to your version of Total Access Emailer)

•	Operating system, processor, and memory that can run Microsoft Access successfully

•	5 MB free disk space.

•	Use of an SMTP Server that allows relay. See Installing an SMTP Server for details.

See Also:

•	Versions Available

•	Installing an SMTP Server

•	Installing the Program

•	Using the Update Wizard

•	Uninstalling the Program


Installing an SMTP Server

To avoid the security limitations of Outlook and MAPI which prompt the user whenever an email is programmatically sent, Total Access Emailer uses an SMTP server to send emails. That is, Total Access Emailer does not use an email client such as Outlook, but an SMTP server instead.

If you have an existing SMTP server, just configure Total Access Emailer to use that using the Options form. If you do not have an existing SMTP server, both Windows 2000 and Windows XP Professional include it for free and make it easy to setup.

	Have your Windows CD handy— you’ll need it to install Internet Information Services (IIS).
Step 1: Install IIS

1.	Open Add/Remove Programs from your Control Panel, and select Add/Remove Windows Components from the menu on the left. This opens the Windows Components Wizard:

Windows Components Wizard

2.	Select Internet Information Services, and press Details:

IIS Details

3.	Check SMTP Service, and press OK. Press Next on the Windows Components Wizard, and Windows installs the service. During installation, you will be prompted to insert your Windows CD.

Step 2: Enable Relay

1.	Open Administrative Tools from your Control Panel, and open Internet Information Services:

IIS Manager

2.	Select Default SMTP Virtual Server, and click on the Properties button:  to open the Properties Form:

Default SMTP Virtual Server Properties

3.	On the Access tab of the Properties form, click on Relay, and add your IP address to the permissions list.

Step 3: Configure SMTP Options

Configure Total Access Emailer to use your computer as the SMTP server. See Send and SMTP Options for details.

See Also:

•	Versions Available

•	System Requirements

•	Installing the Program

•	Using the Update Wizard

•	Uninstalling the Program


Installing the Program XE "installation"  XE "setup"
Installing the Program

Total Access Emailer is installed using an automated setup program. To install Total Access Emailer, follow these steps:

1.	Locate and run the setup program.

2.	When prompted, enter your registration information and product key (serial number).

3.	Specify the destination directory for the files.

4.	Be sure to read the README file for any late breaking news that is not included in this User Guide.

Upgrading From Version X.0

The current version of Total Access Emailer is version X.5 (8.5, 9.5, 10.5, and 11.5 for Access 97, 2000, 2002/XP, and 2003 respectively). Version X.5 replaces version X.0, which was the original release of Total Access Emailer.

Because of add-in conflicts, version X.5 cannot be installed on a computer that has version X.0 installed. If you have the earlier release installed, the setup program prompts you to uninstall before you can install version X.5.

Email blasts created in version X.0 can be run in version X.5 without modification. However, if you use the runtime library to run email blasts programmatically, save the X.0 runtime library if you don’t want to modify your existing deployments. Before uninstalling version X.0, copy the TAEmailR.mde library file from your installation directory to another location.

	Note that you can run multiple versions of Total Access Emailer for multiple versions of Access, as long as you install them to different directories. The conflict only occurs if you try to install multiple releases of Total Access Emailer for the same version of Access (e.g. version 11.0 and 11.5).
See Also:

•	Versions Available

•	System Requirements

•	Installing an SMTP Server

•	Using the Update Wizard

•	Uninstalling the Program


Using the Update Wizard

Total Access Emailer includes a built-in mechanism to check the availability of updates via the Internet. If you have an active Internet connection, you can use the Total Access Emailer Update Wizard to ensure that you have the latest version.

To run this program, select Programs, FMS, Total Access Emailer, Update Wizard from the Windows Start menu. Follow the prompts on the form to check for the latest update.

See Also:

•	Versions Available

•	System Requirements

•	Installing an SMTP Server

•	System Requirements

•	Uninstalling the Program


Uninstalling the Program

To uninstall Total Access Emailer:

1.	From the Windows Start Menu, select Control Panel.

2.	From the Control Panel window, select Add/Remove Programs.

3.	Select Total Access Emailer from the list of installed programs, and press the Change/Remove button.

4.	Follow the onscreen prompts to uninstall the product.

See Also:

•	Versions Available

•	System Requirements

•	Installing the Program

•	Installing an SMTP Server

•	Using the Update Wizard


Learning about the Product

When you install Total Access Emailer, the setup program creates a sample database in your installation directory. This database includes examples of email blasts, and code for using Total Access Emailer’s programmatic interface.

See Also:

•	About Total Access Emailer

•	How Your Database Is Affected

•	Data Sources

•	Starting Total Access Emailer


How Your Database is Affected

Your Data Tables

When you provide a table or query containing email addresses for Total Access Emailer to use, your data is not modified.

The only exception is when you request an audit field to be updated with the date/time the email is sent. To perform auditing and avoid modifying the data table, an option is available to store the audit information in a separate table.

Total Access Emailer Settings Tables

Total Access Emailer creates three tables in your database to store your options and email blast settings:

•	usysTEmailerOptions

•	usysTEmailerSettings

•	usysTEmailerEmbedded

These tables are hidden if "Show System Objects" is not checked in your Access Tools, Options menu.

The email blast settings you specify are stored for reuse. Only the settings are saved, not the data, so the tables take a small amount of space and the current data is always used when you send an email blast.

See How Total Access Emailer Works for details.

Result Tables

Depending on the options you select, tables may be added to your database. For instance, you can choose to send a preview of your email blast to a table, create an audit log in a table, or write errors to a table. In all cases, you can specify the names of these tables.

Temporary Query/View for Embedded Objects

When you embed a filtered Access object, Total Access Emailer creates a temporary query (or a temporary view, in ADPs) to retrieve the subset of data required for each email. The temporary object’s name starts with "usysTEmailer_Temp," and it is removed after the required data is retrieved.

	Since Total Access Emailer creates tables, you may want to work outside your production database. Create a new database and link to your data tables if you don’t want Total Access Emailer to impact your main database.
See Also:

•	Learning about the Product

•	Data Sources

•	Starting Total Access Emailer


Data Sources

Total Access Emailer opens as an add-in through your Access Database (MDB) or Access Data Project (ADP) to work with any native or linked table, or any query or view that provides a list of email addresses. Open Total Access Emailer through your MDB or ADP, and point to your email addresses.

See MDB Data Sources and ADP Data Sources for more information.

See Also:

•	About Total Access Emailer

•	How Your Database Is Affected

•	Starting Total Access Emailer

•	Basics Tab


MDBs
MDB Data Sources

Open your Access Database (MDB), and open Total Access Emailer through the add-ins menu. When you configure your email blast settings, select the table or query that contains your email address information:

MDB Data Source Selection

Total Access Emailer can use data from any native or linked table, including links to non-Access data sources. You can also use data from any query that provides a list of email addresses (of course, it can only update an audit field in a query if the query supports update rights). Using queries allows you to limit the records for the email blast, combine data across multiple tables, and create expressions for fields used to customize email messages.

See Basics Tab for more information on selecting a data source.

See Also:

•	Data Sources


ADPs
ADP Data Sources

In addition to Access MDBs, Total Access Emailer for Access 2000 and later supports Access Data Projects (ADPs). Open Total Access Emailer from your ADP, and point to the data source:

ADP Data Source Selection

Through an ADP, Total Access Emailer can use data from any SQL Server table or view that provides a list of email addresses. Similar to Access queries, views allows you to limit the records for the email blast, combine data across multiple tables, and create expressions for fields used to customize email messages.

See Basics Tab for more information on selecting a data source.

See Also:

•	Data Sources


Starting Total Access Emailer

Total Access Emailer opens as an add-in for Microsoft Access. Open the database containing the email addresses or a database linked to the table(s). If you are using a secured database, be sure to log in as a user with permissions to read and create tables.

After the database is open, launch Total Access Emailer from the Tools, Add-Ins Menu:

Add-Ins Menu

The first time you open Total Access Emailer through a database, you are prompted to configure Total Access Emailer options:

Option Configuration Prompt

If Total Access Emailer is already configured for this database, this prompt is not shown. For more details on setting options, see Send and SMTP Options.

After you configure the options, the Main Menu appears.

See Also:

•	Learning about the Product

•	How Your Database Is Affected

•	Data Sources


Main Menu Overview

The Main Menu is Total Access Emailer’s command center—use it to set up and manage your email blasts. The grid shows the list of email blasts you have created. Click on a row to select one, or use the right-click menu to sort and filter the list just like any Access datasheet.

Main Menu

The buttons along the bottom of the Main Menu provide the features you need to create, manage, test, and send your email blasts:

New

Press the New button to create a new email blast. The Settings Editor appears to let you specify the email blast options.

Edit

The Edit button opens the Settings Editor for the currently selected email blast.

Duplicate

Copying an existing item makes it easy to create new email blasts without starting from scratch. Simply select an email blast and press the Duplicate button. All of the blast’s settings are duplicated with the exception of the ID and the description. The description of the new email blast is "Copy Of" the description from the original. If there was no description, the new description is "Copy of #X" where X is the ID of the original.

	If you always use similar settings for your email blasts, create a "template" email blast with your common settings and duplicate that rather than using the New button.
Delete

Select the email blast to delete, and press the Delete button. After a warning message, the email blast is permanently deleted.

Report

Preview or print a report containing detailed information about the selected email blast’s settings.

Options

Set options for sending emails, SMTP settings, and report paper selection.

Preview

Before sending an email blast to your recipients, it’s a good idea to test it first. The Preview feature lets you send emails to the screen, a table, or an email address you specify, and it even lets you test the auditing features.

Send

When you’re ready to send your email blast, press the Send button. A wizard appears to step you through the process of selecting one or more email blasts, and sending or scheduling for later.

About

The About button displays the product’s version number, registration information, and other product information.

Help

Use the Help button to launch the online help file. The help file includes all the information from the manual, and is fully indexed and searchable.

Exit

Close Total Access Emailer and return to your database.

See Also:

•	Learning about the Product

•	Starting Total Access Emailer


Send and SMTP Options

Before you send any email blasts, you need to specify the send and SMTP Options. Click on the Options button [image] from the Main Menu to configure these settings.

The options are organized into three tabbed panes:

Send Options

SMTP Settings

Report Options

See Also:

•	How Settings are Stored

•	Saving Settings


How Settings are Stored

Total Access Emailer uses the usysTEmailerOptions system table in the current database to store options. Because it uses a table, every user of the database can share the same settings. This is preferable to saving the settings in the Total Access Emailer add-in or registry settings, which could differ for each user.

The drawback of storing settings in a table is keeping settings across multiple databases identical (if that’s desired). Total Access Emailer makes it easy to specify default settings that you can apply to multiple databases.

Default Settings

To make it simple to use the same options across multiple databases, you can specify and save your default settings. These values are stored in your copy of Total Access Emailer.

To save the current settings as your default, press the Save As Default button [image]. This saves all the values across the three tabs.

To replace the current settings with your default settings, press the Retrieve Defaults button [image]. This replaces all values across the three tabs.

See Also:

•	Send and SMTP Options

•	Send Options

•	SMTP Settings

•	Report Options

•	Saving Settings


Send Options

The Send Options tab allows you to specify general options for your email blasts:

Options Form, Send Options

Email Errors

Certain email addresses in your table may violate email format specifications, for instance "Name@Nothing". When Total Access Emailer detects invalid email addresses, it does not attempt to send the email. You can choose to log the error in a separate table so that you can track errors and clean your data.

Table to Store Errors

Specify the name of the table to store errors, or leave this field blank if you do not want to log errors.

If the table does not exist, Total Access Emailer creates it when it encounters an error. Be sure to select a name that does not conflict with an existing table in your database. See Viewing Errors for details.

Overwrite for Each Blast

Select this option if you want the error table to be overwritten each time errors occur in an email blast. Note that the table is not overwritten if you run email blasts, and no errors occur.

If you do not overwrite the table, additional errors are appended to the existing table.

	In environments where multiple people are using the same database, you may encounter conflicts if an email blast is running and another instance of Total Access Emailer tries to overwrite the errors table. If more than one person will be running email blasts at the same time, consider turning off the "Overwrite for each blast" option or having each user write errors to a different table. Alternatively, adopting Access best practices, each user should have their own local application database linked to data in a shared database. This design allows each user to have private tables without multi-user conflict.
Pausing Between Messages

Total Access Emailer does not limit the number of email messages that can be sent, however sending a large number of email messages in a short period of time may overload your mail server or affect network performance.

To prevent overloading your mail server or network traffic, Total Access Emailer includes options to pause after messages are sent. This may be important if you are sending a lot of emails, large HTML messages, or attachments.

Seconds to Wait After Message is Sent

The number of seconds to pause after each message is sent.

Pause after This Many Messages are Sent

In addition to the pause after each email, you may add a longer pause after a specified number of email messages are sent.

Pause for This Many Seconds

The number of seconds Total Access Emailer should pause after the specified number of messages is sent.

Beep After Message Sent

Select this option to hear a beep after each message is sent. This is helpful if you launch an email blast and want a continuous reminder that messages are being sent, or a way to tell if the email blast slows or stops for any reason.

See Also:

•	Send and SMTP Options

•	How Settings are Stored

•	SMTP Settings

•	Report Options

•	Saving Settings


SMTP Settings

The SMTP Settings tab allows you to specify the information required to send mail through your mail server:

Options Form, SMTP Settings

Mail Server

Specify your mail server settings and login information. Contact your network administrator if you have questions about these settings, or refer to Installing an SMTP Server for more information.

	In order to send emails using Total Access Emailer, your mail server must allow relay. Contact your network administrator if you have questions about your mail server’s configuration, or see Installing an SMTP Server for more information.
Connection Type

Select the type of connection to use to connect to your mail server:

•	SMTP (Simple Mail Transfer Protocol) is the most common protocol used to send and receive email.

•	ESMTP (Extended Simple Mail Transfer Protocol) extends SMTP to supports graphics, audio and video files, and text in various national languages.

•	SSL (Secure Socket Layer) is used if the server requires a secure or encrypted connection.

Mail Server Name

Type the name of the mail server to use to send the message. The mail server may or may not be configured to require authentication.  If your mail server requires authentication, specify a logon name and password:

Logon Name

If the mail server requires authentication, type the logon name of a user with permissions to send mail through the server.

Logon Password

If the mail server requires authentication, type the password for the logon name specified above.

Port

The port number specifies which port number Total Access Emailer uses to establish a connection with the mail server.

The default port number for most SMTP/ESMTP mail servers is port 25 or 465 for servers that require SSL. Total Access Emailer uses these values for its defaults. If your mail server uses a different port number, change the value in Total Access Emailer to match your mail server.

Firewall Settings

If the computer that is running Total Access Emailer goes through a firewall to get to the SMTP server, enter your firewall settings here. Contact your network administrator if you have questions about your firewall settings.

Host

Type the name of the firewall host.

Logon Name

Type the logon name of a user with permissions to send mail through the firewall.

Password

Type the password for the logon name specified above.

Port

Enter the firewall port number.

Type

Select the firewall type: None, Socks4, Socks5, Proxy, or Pipe.

See Also:

•	Send and SMTP Options

•	How Settings are Stored

•	Send Options

•	Report Options

•	Saving Settings


Report Options

The Report Options tab allows you to specify the paper size used for the email blast report and the results report. It also allows you to preview and print the results report for the last email blast that you sent:

Options Form, Report Options

Paper Size

Select the paper size for printing the email blast report and the results report:

•	US Letter (8.5 by 11 inches)

•	A4 (210 by 297 millimeters)

Preview Last Email Blast Report

Click this button to preview the results report for the last email blast that was sent.

See Also:

•	Send and SMTP Options

•	How Settings are Stored

•	Send Options

•	SMTP Settings

•	Saving Settings


Saving Settings

If the settings you’ve specified is your standard configuration, press the Save as Default button [image] to store the values in the Total Access Emailer add-in. This ensures that you can restore these settings if they are inadvertently overwritten, and easily replicate them in other databases. See How Settings are Stored for details.

See Also:

•	Send and SMTP Options

•	Send Options

•	SMTP Settings

•	Report Options


Email Overview

Before creating email blasts with Total Access Emailer, you should be familiar with the layout of an email message and the sections that Total Access Emailer can customize:

From   : Sender@MyDomain.com
To     : Recipient@domain.com
Cc     : Associate@domain.com
Bcc    : Boss@MyDomain.com
Subject: Read This Important Message

< Text or HTML Message >

Email Sample

From Address

The email address the recipient sees as the source of the email.

To Address

The recipient’s email address. There may be multiple recipients.

Cc Address

A Cc (carbon copy) email address receives a copy of the message, and its email address is visible to other recipients of the message. There may be multiple Cc email addresses.

Bcc Address

Bcc (blind carbon copy) is similar to a Cc, except this email address is not visible to other recipients of the message. There may be multiple Bcc email addresses.

Subject

The topic of the message.

Message

An email message can be a plain text message or HTML-formatted message with graphics, fonts, styles, paragraph formatting, hyperlinks, etc.

See Also:

•	Email Blast Overview

•	Advanced Customization


Email Blast Overview

From the Main Menu, press the New button [image] or select an existing email blast and press the Edit button [image] to display the Settings Editor:

Settings Editor

This form lets you configure and save your email blast. It is organized into these tabs:

•	Basics Tab
Basic email blast information, such as description, table and email field to use, message subject, message format, and other message options.

•	Addresses Tab
Options for FROM, TO, Cc, and Bcc addresses.

•	Text Header
The header for messages in Text format.

•	Text Body
The message body (main section) for messages in Text format.

•	Text Footer
The footer for messages in Text format.

•	HTML Tab
The HTML message.

•	Attachment Tab
Optional files and embedded Access objects to attach to your message.

•	Auditing Tab
Optional features to document what messages were sent, whom they were sent to, and when they were sent.

•	Statistics Tab
Historical statistics for the email blast, including when it was created, last modified, last sent, the number of messages sent, etc.

See Also:

•	Email Overview

•	Advanced Customization


Basics Tab

The Basics tab contains the most important settings for the email blast:

Settings Editor, Basics Tab

Description

This is the descriptive text for the email blast. This text is displayed in the list on the Main Menu, and helps you identify this email blast in the future. This text is for your use only—email recipients never see the description.

Data Source with Email Addresses

The table, query, or view containing the email addresses. This can be any local table, linked table, query, or view in the MDB or ADP. Use the Browse button [image] to select the source. See Data Sources for more information.

Field Containing the Email Addresses

The field in the table or query that holds the email addresses. Emails are sent to the email address specified in each record of this field. Blank values are ignored.

	Your data source may include a display name for the recipient (in addition to the email address) using this syntax: FMS Customer Service <fms@fmsinc.com> In the example above, "FMS Customer Service" would be displayed in the email received by fms@fmsinc.com.
Message Subject

A custom subject line gives your message a personal touch and sense of importance the first time your recipient sees it. For instance, if your subject is:

Meeting with [Organizer] at [StartTime]

A recipient could receive an email with this subject:

Meeting with Molly at 3:00 PM

The subject field allows 255 characters; if you use a file or a field, the first 255 characters will be used, and the remainder (if any) will be truncated. If the subject you provide in the file or field contains multiple lines (lines separated by a carriage return, not word wrapping), only the first line is used.

The subject line of the email can be specified directly as text, from a file, or from a field. For more information see Source Options.

Message Format

The format used to send the message:

•	Text Only
Message is sent as plain text. If you select this option, the HTML tab is disabled.

•	HTML Only
Message is sent in HTML format only. If you select this option, the Text Header, Text Body, and Text Footer tabs are disabled.

•	Text and HTML
Some recipients receive text, and others receive HTML. The format for each recipient is based on the field that you specify.

Designating Text or HTML Message

If you choose "Text and HTML" as the format, you can specify the field and value to determine the message format for recipients, or send both formats and let the recipient’s email client determine which to display.

Field for Text or HTML

The field that determines which format to use for each recipient.

Leave this field blank to send both messages. If the recipient’s email supports HTML, they will see the HTML message; otherwise, they will see the plain text message.

When Field Value Equals

The value to look for in the specified field.

For Yes/No fields, use a -1 for Yes (True), or a 0 for No (False).

Send this Message Type

The format to use when the field value is equal to the value that you specified (HTML or Text).

Message Options

Priority

This setting determines the priority the recipient sees when viewing the message: Urgent, High, Normal, Low, or Lowest.

Sensitivity

This setting determines the sensitivity level the recipient sees when viewing the message: Normal, Personal, Private, or Confidential.

Request a Delivery Receipt

Use this option to track when messages are delivered. With this option checked, you will receive a message delivery notification at the From address.

	The delivery receipt will only work properly if the email recipient’s mail server supports delivery receipts and is configured to allow automatic replies. Many mail servers do not support this, so you may not receive a delivery receipt from some recipients. Consider using the Read Receipt option, which does not require the server to send automatic replies.
Request a Read Receipt

Use this option to track when messages are read. With this option checked, you will receive a notification at the From address when the recipient reads your email.

See Also:

•	Email Overview

•	Email Blast Overview

•	Addresses Tab

•	Text Tabs: Header, Body, and Footer

•	HTML Tab

•	Attachment Tab

•	Auditing Tab

•	Statistics Tab

•	Advanced Customization


Addresses Tab

The Addresses tab allows you to specify email address options:

Settings Editor, Addresses Tab

FROM Address

The FROM address of the email lets the recipient know who sent the email. This can be different from the FROM address used on that machine’s Outlook or other email program.

Only one FROM address can be used. If the file or field includes multiple lines, only the first line is used.

The FROM address can be specified directly as text, from a file, or from a field. For more information see Source Options

	You can optionally enter the display name of the sender (in addition to the From email address) by using this syntax:   FMS Customer Service <fms@fmsinc.com> In the example above, "FMS Customer Service" would be displayed in the email, and the From address would be fms@fmsinc.com.
TO Address Options

Emails can be sent individually to each email address or in bulk with one message for many email addresses. Individual "standard" emails support customization for each recipient and appear to be individually sent. Bulk emails are faster to process, but are less personal.

Standard

A separate email is sent to each email address in the list. The single recipient is the only email address that appears in the TO line of the email. The use of field references for the subject and message provides individual customization that’s not available in bulk emails, making the message feel more personal.

Selecting Standard also supports the "Text and HTML" Message Format option for each recipient.

Bulk Mailing

A bulk email sends one email to multiple email addresses at the same time. This gives the message a much less personal feel, since the recipient’s email address does not appear in the TO line, and since other email addresses may also be shown. If you use field references, the data from the first email in each group is used to customize the message. The options for a bulk mailing are:

•	To address for sending bulk mailing messages
This email address appears in the TO line of the email, and it receives a copy of each email that is sent. You may leave this blank.

•	Number of addresses per message
The number of email addresses you want to group into one email. The more you select, the faster the email blast is sent. The drawback is that in some email systems, if one of the addresses is bad, the entire email may fail (no recipients in the group will receive it).

•	How to Display Recipient Email Addresses
The recipients’ email addresses can be displayed in the Cc line (visible to all recipients) or the Bcc line (hidden from all recipients). If it’s not a group of people who already know each other, you should generally select Bcc to avoid violating anyone’s privacy.

Duplicate Email Addresses

Total Access Emailer includes a special feature to avoid sending duplicate emails when using the Bulk email option.

When using the Standard email option, you may want to send multiple emails to the same email address, since your message may differ based on the field references. Bulk email recipients, however, all receive the same message, eliminating the need to send duplicate messages to the same email address.

While a Bulk email blast is being sent, Total Access Emailer checks the current email address against the previous one. If the address is identical, it is skipped and an entry is made in the Errors table. For this to work, your data source should be a query sorting the data by email address. Total Access Emailer does not try to catch duplicates in your entire data set, just the previous record.

	If you want to be sure to eliminate duplicate email addresses, you can create a query grouped by the email field. If you use a Group By query, however, you cannot update an audit field, so you may want to consider eliminating duplicates externally prior to running your email blast.
Optional Settings

Regardless of whether you choose Standard or Bulk email, you can optionally include an email address to receive a Cc or Bcc. For each email that goes out, a copy is sent to the email address specified. This is another way, in addition to auditing, for you to verify emails were sent.

If you choose to send a Bulk email with the Cc option, the Cc address in the Optional Settings is appended to the Bulk email Cc. The same applies for Bcc.

	Instead of typing an email address for the Cc or Bcc option, you can reference a field in your data source by referencing the field name in brackets. For instance, if the field containing the Cc address is named "CcAddress," type [CcAddress] in the Cc field.  For more information, see Field References.
See Also:

•	Email Overview

•	Email Blast Overview

•	Basics Tab

•	Text Tabs: Header, Body, and Footer

•	HTML Tab

•	Attachment Tab

•	Auditing Tab

•	Statistics Tab

•	Advanced Customization


Text Tabs: Header, Body, and Footer

These three tabs are not available if the Message Format is set to HTML Only.

There is no specific definition for what should be included in the text header, body, or footer—you should decide what works best for you. In many cases, you may have no need to separate the message into multiple parts, so you only need to use the Text Body.

By separating the text message into three parts, Total Access Emailer gives you the flexibility to use the same text for a section across multiple email blasts, making it easier to manage email blasts and maintain consistency.

You can reference a file rather than using hard-coded text to make it even easier to update email blasts. For instance, you may want the end of each message to contain contact information, such as a name, phone number, and email address. By storing this as a text file, you can easily make changes in one location while maintaining consistency. If the person changes, for example, you just need to edit the file and all email blasts that use it are updated with the new information.

Three tabs are available for creating text messages:

•	Text Header

•	Text Body

•	Text Footer

The message sent is the combination of the text specified across the three tabs.

Settings Editor, Text Header Tab

Settings Editor, Text Body Tab

Settings Editor, Text Footer Tab

For each section, select one of the following Source Options

•	None: No text is sent for the section.

•	Text: Type or paste the text directly into the field.

•	File: Retrieve the text from a file.

•	Field: Point to a field in the data source that contains the text message.

The Text Body tab includes this additional option:

•	Embedded Object: Embed an Access table, query/view, or report as the message body. The embedded object can be unfiltered so that every recipient receives the same data, or filtered so that each recipient’s message is unique (e.g., send customers only their own price lists).

For more information about message customization see Advanced Customization.

See Also:

•	Email Overview

•	Email Blast Overview

•	Basics Tab

•	Addresses Tab

•	HTML Tab

•	Attachment Tab

•	Auditing Tab

•	Statistics Tab

•	Advanced Customization


HTML Tab

This tab is not available if the Message Format is set to Text Only.

Use the HTML tab to specify the HTML email message.

Settings Editor, HTML Tab

Select one of the following source options for the HTML message:

•	None: No HTML message is sent.

•	Text: Type or paste the HTML for the message, or use the Import button [image] to import it from a file. Press the Preview HTML [image] button to preview the message in your browser.

•	File: Retrieve the HTML from a file.

•	Field: Point to a field in the data source that contains the HTML message.

•	Embedded Object: Embed an Access table, query/view, or report as the HTML message. The embedded object can be unfiltered so that every recipient receives the same data, or filtered so that each recipient’s message is unique (e.g., send customers only their own price lists).

	If your HTML message references local graphics, Total Access Emailer automatically embeds them in the email message.
For more information on message customization see Advanced Customization.

See Also:

•	Email Overview

•	Email Blast Overview

•	Basics Tab

•	Addresses Tab

•	Text Tabs: Header, Body, and Footer

•	Attachment Tab

•	Auditing Tab

•	Statistics Tab

•	Advanced Customization


Attachment Tab

The Attachment tab lets you specify the files and embedded Access objects to attach. You can use the same files for everyone, or send a unique set of files to each email address.

Settings Editor, Attachment Tab

Attachment Files

Select one of the following source options for Attachments:

•	None: No files are attached.

•	Files: Use the Add button [image] to browse for files to attach, and the Delete button [image] to remove files from the list.

•	Field: Point to a field in the data source that contains the files to attach.
If you want to send different files to each recipient, your email source should include a field for the files to attach. In the field, enclose file paths in parenthesis, and separate files with semicolons, e.g.:

	If you attach HTML files that include graphics, Total Access Emailer cannot automatically embed the graphics. In attached files, be sure that any graphics are publicly available on the Internet (or a shared network drive for messages sent only to people on your network).

For more information on these options, see Source Options.

Attach Embedded Objects

In addition to attaching files, Total Access Emailer lets you embed Access tables, queries/views, and reports as attachments. These attachments can unfiltered to send every recipient the same embedded object, or filtered to be customized for each recipient (e.g., send recipients only their own invoices).

Click the Add button [image] to add a new embedded attachment. See Attaching Embedded Objects for more information.

See Also:

•	Email Overview

•	Email Blast Overview

•	Basics Tab

•	Addresses Tab

•	Text Tabs: Header, Body, and Footer

•	HTML Tab

•	Auditing Tab

•	Statistics Tab

•	Advanced Customization


Auditing Tab

Total Access Emailer includes optional auditing features to track when you sent an email to each recipient. Audit information can be stored in a date/time field in the data source or in a separate table.

In addition to simply documenting emails, the Audit Field allows Total Access Emailer to pick up where you left off if the email blast is canceled or fails for any reason. It also enables you to send the email blast to new names on your list without sending it to people who already received it.

The Auditing tab allows you to customize this tracking:

Settings Editor, Auditing Tab

Audit Field

The Audit Field is a date/time field in your data source that gets updated when Total Access Emailer sends an email to the record’s email address. If your data source is a query, it must be an updatable query.

	If you have multiple email blasts for the same table, and you want the ability to restart an email blast if it fails, you should have a separate audit field for each blast.
Update this Date/Time Field

Check this option to activate the Audit Field feature.

Date/Time Field

Select the date/time Field to store the date and time when the record’s email is sent.

Clear this Field

With this option selected, the Audit Field is cleared for all records each time the email blast is sent. This makes it possible to resend the email blast if it failed, without sending emails to those who already received it (records with a value in the Audit Field).

If this option is not selected, the audit field may already have values, and the records are simply updated when the email is sent.

Audit Table

Instead of (or in addition to) modifying your existing table with an Audit Field, you can store audit information in a separate table.

Audit Log Table

This option allows you to keep track of the emails that were sent, but does not allow you to pick up the email blast where it left off. If you want the ability to send emails only to people you have not sent to, use an audit field that is cleared each time the email blast is sent.

Store Audit Log in Table

Select this option to activate the Audit Table feature.

Table Name

Enter the name of the Audit Table. If the table does not exist, it is created automatically.

Overwrite Table

Select this option to overwrite the table every time the email blast is sent. If this option is not selected and the audit table already exists, the audit log is appended to the existing data. If you send many emails, this table can grow very large so you’ll need to monitor it.

	In multi-user environments, you may encounter conflicts if an email blast is running and another instance of Total Access Emailer tries to overwrite the audit log. If more than one person will be running email blasts at the same time, consider turning off the "Overwrite table" option, or having each email blast write the audit log to a different table.
Optional Fields to Store

The audit table always includes the email address and the time the email was sent. You can optionally choose to store additional information:

•	ID field
The email record’s unique identifier (select a numeric field from your data source). This is displayed in the DataSourceID field.

•	Subject
The email’s subject line.

•	Attachment
The name of the file or files attached to the message. The actual file is NOT added to the audit table, only the file path.

•	Message
The text and/or HTML message that was sent

Remember that the more fields you store, the larger the table becomes. If disk space is a concern, consider not including the optional fields.

See Also:

•	Email Overview

•	Email Blast Overview

•	Basics Tab

•	Addresses Tab

•	Text Tabs: Header, Body, and Footer

•	HTML Tab

•	Attachment Tab

•	Statistics Tab

•	Advanced Customization


Statistics Tab

Total Access Emailer automatically tracks certain statistics for your email blasts. The Statistics tab displays historical information about the email blast and the times it was sent:

Settings Editor, Statistics Tab

This Email Blast’s Historic Statistics

This section displays the overall history of the email blast, including:

•	First time the blast was sent

•	Number of times the blast was sent

•	Total number of messages sent since it was created

•	Last time finished
(completed without cancellation or failure)

Last Email Blast Statistics

This section displays information about the last time this email blast was sent, including:

•	Last time it was started

•	Time that it was restarted
(blank unless it was resent due to a failure)

•	Time that it completed successfully
(blank if the last attempt failed)

•	Number of messages sent the last time it was run

Creation and Modification Information

This section displays information about the creation and modification of the email blast settings, including:

•	Windows login name of the user who created it

•	Windows login name of the user who last modified it

•	Date it was created

•	Date it was last modified

See Also:

•	Email Overview

•	Email Blast Overview

•	Basics Tab

•	Addresses Tab

•	Text Tabs: Header, Body, and Footer

•	HTML Tab

•	Attachment Tab

•	Auditing Tab

•	Advanced Customization


Advanced Customization

When emailing a list of contacts, you want each email to be as personal as possible. This may be as simple as including the recipient’s name in the subject line, or as complex as sending each person unique data that only applies to them.

Total Access Emailer includes several advanced features that make customization easy. Using these features, you can personalize each email message according to your needs:

Field References

Field References let you customize emails with field values from your data source. Simply reference field names, and when the email is sent, each field reference is replaced with the field value from the current record.

Source Options

Several of Total Access Emailer’s settings include options for where to get their values:

•	Text: Simply type the value that you want to use.

•	File: Reference a file containing the value, making it easy to share identical settings across email blasts.

•	Field: Personalize emails for recipients by getting the value from a field in your data source.

Embedded Objects

Total Access Emailer allows you to embed Access tables, queries/views, and reports in your email. Either use embedded objects as the email message, or as attachments in html, rtf, snp, txt, or xls format.

Filtering options give you the flexibility that you need to send every recipient the same embedded object, or customize it to send different data to each recipient.


Field References

Field References are one of the most powerful features in Total Access Emailer—they let you easily customize your emails with field values from your data source record. Simply reference as many field names as you want, enclosed in brackets. When the email is sent, each field reference is replaced with the field value from the current record.

For instance, if you specify the message header as:

Dear [FirstName],

The bracketed text is replaced with the value in the FirstName field. That is, if the record’s FirstName field contains "Molly", the recipient’s message header becomes:

Dear Molly,

Using the fields in your email table or creating a query to link it to other related tables leverages the power of Access to generate personalized emails. The customization possibilities are endless.

The following settings can be customized using Field References:

•	Subject

•	Cc Address

•	Bcc Address

•	Text Header

•	Text Body

•	Text Footer

•	HTML Text

	Total Access Emailer only replaces field references with field values. If you want to use an expression, math formula, VBA command (e.g. IIF, UCase, etc.), or your own function, use a query as your data source with calculated fields containing the value you desire. Then reference the query’s fields in your email blast. For more details, see the Access online help for creating custom calculations in queries.
More Information

•	Use Field References

•	Field References—Can Shrink

See Also:

•	Advanced Customization

•	Source Options

•	Embedded Objects


Use Field References

To instruct Total Access Emailer to replace Field References with field values, check this option:

If you reference a field that doesn’t exist, the text with brackets is displayed unchanged. This allows you to use brackets in your text in addition to brackets for field references.

If "Use field references" is unchecked, text with brackets is simply treated as regular text (both the brackets and the text appear in the message).

	The Cc address and Bcc address fields do not include a "Use field references" check box—field references are always accepted for these settings. Simply enclose the field name in brackets, and it is replaced with the value from your data source.
See Also:

•	Advanced Customization

•	Field References

•	Field References—Can Shrink


Field References—Can Shrink

The Field References "Can Shrink" option is similar to the Can Shrink property in Access reports. If checked, the text shrinks vertically if rows reference fields with no value.

For instance, assume you use these specifications:

Customer Information:
  [FirstName] [LastName]
  [Company]
  [Address1]
  [Address2]
  [City], [State] [ZipCode]

Sample Text Specifications

If some of the values are missing and Can Shrink is not checked, the text may appear with blank lines:

Customer Information:
  Molly Pell
  FMS, Inc.
  8150 Leesburg Pike, Suite 600

  Vienna, VA 22182

Sample with No [Address2]

With Can Shrink selected, blank lines are removed:

Customer Information:
  Molly Pell
  FMS, Inc.
  8150 Leesburg Pike, Suite 600
  Vienna, VA 22182

Sample with No [Address2]

The Can Shrink option removes the line with a field reference that doesn’t exist. If the line has any text (other than spaces), it is not removed.

	For HTML messages with Can Shrink checked, Total Access Emailer replaces field references with a blank value and removes any blank space around it. However, the complexity of HTML tags prevents the removal of HTML codes, including paragraph settings without risking the integrity of the entire message.  Some HTML browsers may display blank lines when Total Access Emailer replaces a field reference with a blank value, however many HTML browsers automatically shrink multiple blank lines for display, so the message will display properly.
See Also:

•	Advanced Customization

•	Field References

•	Use Field References


Specifying the Values
Source Options

Several of Total Access Emailer’s settings include various options for where to get their values, including:

•	Subject

•	From Address

•	Text Header

•	Text Body

•	Text Footer

•	HTML

•	Attachments

Text

The simplest way to specify a field value is to type the text that you want to use. For example, if you want all emails to have the subject "Monthly Newsletter," you could select the "Text" option and type "Monthly Newsletter" in the text box:

Message Subject, Text Option

File

Instead of typing the text, you can choose to reference a file containing the value that you want to use. This option is useful if many of the email blasts that you send use the same value. For example, if you always include the same signature line, you can point to a text file for the Text Footer:

Text Footer, File Option

If you need to update any of the information, you can change it in the text file, and it is updated in all email blasts. In a multi-user environment be sure the file is in a shared directory and doesn’t use mapped drives that may vary among users.

Field

You can further customize individual emails by getting values from a field in your data source. This option offers the potential for unique values for each email address.

For example, you may want the email’s From Address to vary depending the recipient’s sales representative. In this case, you could create a query that includes the recipient’s email address, as well as their sales representative’s email address, and point to the appropriate field for the From Address:

From Address, Field Option

Embedded Object

In addition to the other source options, Text Body, HTML, and Attachments let you embed an Access object. See Embedded Objects for details.

See Also:

•	Advanced Customization

•	Field References

•	Embedded Objects


Embedded Objects

In addition to the other source options, Total Access Emailer can embed Access tables, queries/views, and reports for the following settings:

•	Text Body

•	HTML

•	Attachments in text, HTML, Excel, rich text (RTF), and report snapshot formats.

Filtering options give you the flexibility to send every recipient a customized subset of the embedded object.

This is particularly powerful when embedding reports as your HTML message. Use the power of the Access report generator to create nicely formatted reports with complex calculations and displays. Manually export them to HTML format to verify they appear the way you want, and then embed them in your email.

More information:

•	Testing Objects before Embedding Them

•	Embedding an Object as the Email Message

•	Attaching Embedded Objects

See Also:

•	Advanced Customization

•	Field References

•	Source Options


Testing Your Objects before Embedding Them
Testing Objects before Embedding Them

Before embedding an object in your email, use Access interactively to design and export the object to the desired format (e.g. text, HTML, etc.). This lets you see what the output is like with the ability to modify the object. This is particularly helpful when embedding a report.

Exporting a Report to HTML Format

From Access, simply preview your report and export it to HTML format.

In Access 2000, 2002, and 2003, this is available under the File, Export menu. Choose the "HTML Documents (*.html, *.htm)" option under Save as Type, and optionally choose an HTML template.

In Access 97, select File, Save As/Export, then choose to save "To an External File or Database", followed by the HTML Documents type.

HTML Limitations and Adjustments of Reports

Access reports exported to HTML do not include graphics that are on the report, since they are not HTML format. To include graphics on reports exported to HTML, use an HTML template file.

The HTML exports of Access reports include navigation hyperlinks to additional pages. These are not included when you embed the HTML report into your email.

	By embedding Access reports as your HTML message, you can use the Access report writer to create very nicely formatted emails with data.
See Also:

•	Advanced Customization

•	Embedded Objects

•	Embedding an Object as the Email Message

•	Attaching Embedded Objects


Embedding an Object as the Email Message

Instead of specifying the text, file, or field to use for the email message, consider embedding an Access object. This feature lets you customize email messages based on your Access data, as well as all of the features in Access.

The Text Body tab includes the Embedded Object option for the message source:

Embedded Object Option for Text Message

Click the Browse button [image] to open the Embedded Object Specifications form for the text message:

Embedded Object Specifications Form for Text Message

The HTML tab includes a similar option:

Embedded Object Option for HTML Message

Click the Browse button [image] to open the Embedded Object Specifications form for the HTML message:

Embedded Object Specifications Form for HTML Message

This form includes the following options:

•	Embedded Object Fields

•	Embedded Object Filter Options

•	HTML Template File for Embedded Objects

•	Testing and Saving Embedded Objects

See Also:

•	Advanced Customization

•	Embedded Objects

•	Testing Objects before Embedding Them


Embedded Object Fields

Use the fields at the top of the Embedded Object Specifications form to specify the object to embed. First, select the type of Access object to embed: table, query/view, or report:

Embedded Object Type

Then select the name of the Access object to embed:

Embedded Object Name

See Also:

•	Advanced Customization

•	Embedded Objects

•	Testing Objects before Embedding Them

•	Embedding an Object as the Email Message

•	Embedded Object Filter Options

•	HTML Template File for Embedded Objects

•	Testing and Saving Embedded Objects

•	Attaching Embedded Objects


Embedded Object Filter Options

Use the Embedded Object Filter options to customize the data that is sent to each recipient.

No Filter

Select the "No Filter" option to send all data to every recipient:

Embedded Object, No Filter

When this option is selected, every email contains the same data.

One Field

Select the "One Field" option to filter the embedded object by specifying a field in the embedded object to match with a field in the data source:

Embedded Object, One Field Filter

For example, if your data source is a list of Customers, and your embedded object is an Invoice report, match the CustomerID field from the Invoice report to the ID field from the Customers table to only send customers their own invoices.

Multiple Fields

Select the "Multiple Fields" option to filter the embedded object by matching multiple fields in the embedded object with multiple fields in the data source. Separate the field names with semicolons:

Embedded Object Multiple Fields Filter

For example, if your data source is a list of incomplete addresses, and your embedded object contains valid city/state/zip combinations, match the City and State fields from the embedded object to the City and State fields from the data source to send a list of city/state/zip combinations.

Advanced (Custom WHERE)

The "Advanced" option is the most complex, but also the most powerful filter feature. Using the advanced filter, you can create a filter using the same expressions as a query’s WHERE clause, including:

•	Field Names from the embedded object (enclosed in brackets, e.g. [EmbeddedObjectField])

•	Field Names from the data source (enclosed in curly braces, e.g. {DataSourceField})

•	Logical operators (e.g. <, >, =, And, Between, In, Like, Or, etc.)

•	Access Functions (e.g. InStr(), Abs(), Date(), IsNull(), Len(), Date(), etc.)

Embedded Object, Advanced Filter

For example, you may want to send customers their own invoices from today, only if they owe money and the invoice is not canceled. To do this, use the following clauses:

•	Match the CustomerID field from the Invoice report to the ID field from the Customers table:
    [CustomerID] = {ID}

•	Use the Date() function to match the OrderDate field from the Invoice report to the current date:
    [OrderDate] = Date()

•	Use the > operator to filter for AmtDue > 0:
    [AmtDue] > 0

•	Filter out Canceled invoices:
    [Cancel] = False

Join these clauses using the AND operator, and enter them in the Advanced filter field in this format:

    [CustomerID]={ID} AND [OrderDate]=Date()AND [AmtDue]>0 AND [Cancel]=False

Skip the Email if the Embedded Object is Empty

In some cases, the filter options you specify will return no data for certain records in your data source. For example, assume that a customer has no unpaid invoices. Instead of sending them an empty email message, you can select the "Skip the Email if the embedded object is empty" option. With this option on, emails that would otherwise be blank are skipped (the email is not sent).

No Data Event for Reports

By default, opening a report with no data triggers an error. This is a problem if you are filtering a report and one of your records would generate no results.

To avoid this possibility, add a No Data event to the report. Simply add an Event Procedure to the report’s On No Data event by selecting [Event Procedure] from the drop down list:

Adding a No Data Event to a Report

Click on the [image] button to open the code editor:

New No Data Event Procedure

Simply add one line to cancel the report if there is no data:

Code to Close an Access Report with No Data

See Also:

•	Advanced Customization

•	Embedded Objects

•	Testing Objects before Embedding Them

•	Embedding an Object as the Email Message

•	Embedded Object Fields

•	HTML Template File for Embedded Objects

•	Testing and Saving Embedded Objects

•	Attaching Embedded Objects


HTML Template File
HTML Template File for Embedded Objects

Like Microsoft Access, Total Access Emailer also allows you to optionally select an HTML template file when you embed an object in HTML format. If you do not specify an HTML template file, Microsoft Access provides a default scheme.

An HTML template file can enhance the appearance and consistency of objects exported to HTML by adding graphics, background colors, styles, formatting, etc. HTML template files can also use tags and tokens that are unique to Microsoft Access, and indicate where to insert your data.

For more information about HTML template files, search the Microsoft MSDN library for "HTML template files."

	When you export Access reports to HTML, the file does not include graphics from the report, since they are not HTML format. Using an HTML template file is a great way to add graphics to objects exported to HTML.  If you embed an Access object as the HTML message, and you choose a template file that references local graphics, Total Access Emailer automatically embeds the graphics in the email message.  However, if you attach Access object, and you choose a template file with graphics, Total Access Emailer cannot automatically embed the graphics. In attached files, point to graphics that are publicly available on the Internet (or a shared network drive for messages sent only to people on your network).
See Also:

•	Advanced Customization

•	Embedded Objects

•	Testing Objects before Embedding Them

•	Embedding an Object as the Email Message

•	Embedded Object Fields

•	Embedded Object Filter Options

•	Testing and Saving Embedded Objects

•	Attaching Embedded Objects


Testing and Saving Embedded Objects

Before saving the Embedded Object Specifications form, use the Test button [image] to test the filter options. This opens a preview of the data that will be sent to the first recipient in your data source.

When you are satisfied that your embedded object specifications are correct, click OK to return to the Settings Editor.

See Also:

•	Advanced Customization

•	Embedded Objects

•	Testing Objects before Embedding Them

•	Embedding an Object as the Email Message

•	Embedded Object Fields

•	Embedded Object Filter Options

•	HTML Template File for Embedded Objects

•	Attaching Embedded Objects


Attaching Embedded Objects

Total Access Emailer allows you to specify one or more objects to attach to your emails. In addition to attaching objects from a file or a field in your data source, you can also attach embedded Access tables, queries/views, and reports. Embedded attachments can be sent as html, rich text (rtf), snapshot (snp), txt, or Excel (xls) files.

	You must have the Microsoft Snapshot Viewer installed in order to embed attachments in snapshot format. Download it for free from Microsoft’s web site or install it from your Access/Office CD.

The Attachment Tab includes the following grid for managing embedded attachments:

Attach Embedded Objects

The following options are available:

	Opens the Embedded Object Specifications form to let you attach a new embedded object.
	Opens the selected embedded attachment for editing.
	Copies the selected embedded attachment.
	Deletes the selected embedded attachment from the list.
When you click the Add or the Edit button, the Embedded Object Specifications form opens:

Embedded Object Specifications Form

Attaching an embedded object is identical to embedding an object as the email message except that two additional fields are available:

•	Output Format
Select the format of the attachment. Embedded attachments can be sent as html, rtf, snp, txt, or xls files.

•	Attachment File Name in Email
Type the name to use for the attached file. This name is what the email recipients see when they receive the attachment.

Refer to the following sections for details about the options on this form:

•	Embedded Object Fields

•	Embedded Object Filter Options

•	HTML Template File for Embedded Objects

•	Testing and Saving Embedded Objects

See Also:

•	Advanced Customization

•	Embedded Objects

•	Testing Objects before Embedding Them


Email Blast Report

After configuring your email blast, it may be helpful to review detailed information about its settings. Click the Report button [image] on the Main Menu to open the Email Blast Report:

Email Blast Report

The report contains information about all of the settings and statistics for the email blast, organized by the tabs on the Settings Editor. Preview the report to ensure that the settings are correct, or print it for your records.

This report prints in US Letter or A4 format, depending on the settings you selected on the Options form. To change the paper size, press the Options button [image] and modify the setting on the Report Options tab.

See Also:

•	Previewing an Email Blast

•	Verifying Results

•	Verifying Data


Previewing an Email Blast

Before sending an email blast to your recipients, it’s critical to test and verify your message. Total Access Emailer includes a powerful Preview feature, which makes it easy to check your email blast before sending.

	Always preview messages prior to sending an email blast. Use the preview options to ensure that any field references are replaced properly, and that the From, To, Cc, Bcc, and subject fields are correct. You should also review the message text to ensure that there are no errors or typos.
From the Main Menu, select the email blast to test, and click the Preview button [image] to open the Preview Options form:

Email Preview Options Form

The following options are available:

Number of Records to Preview

Specify the maximum number of records from your data source to preview. Total Access Emailer retrieves your data and generates the individual emails for these records.

Note that for Bulk Mailings, the number of messages is smaller than the number of records.

Where do you want to send the Email?

You can send the email to the screen, a table, or an email address.

•	Send Email to Screen

•	Send Email to This Table

•	Send All Emails to This Email Address

Perform Audit Features

Check the Perform Audit Features check box to track the email blast with the settings specified on the Auditing Tab:

When you perform audit features during preview, only the emails that you preview are audited. That is, if your data source contains 100 email addresses, but you only preview 5, only the 5 that you preview will be tracked.

	When you perform audit features, your data is updated exactly the same as when you send the email blast. The audit field or table might reflect that an email was sent to a particular record, when in fact that record was only included in the preview.  Because of this, you should not perform audit features if you plan to resend an email blast to people who did not previously receive it.
See Also:

•	Email Blast Report

•	Verifying Results

•	Verifying Data

•	Launching the Email Blast

•	Viewing the Results


Send Email to Screen

Select this option to preview the emails on the screen. When you press OK, the Sample Messages form displays the emails:

Preview Sample Messages

If your message is in HTML format, the message shows on the HTML tab. Use the Preview HTML button:  to view the message in your browser.

See Also:

•	Email Blast Report

•	Previewing an Email Blast

•	Send Email to This Table

•	Send All Emails to This Email Address

•	Verifying Results

•	Verifying Data


Send Email to This Table

Select this option to send the emails to a table in your database, and enter the name of the table for Total Access Emailer to create. If it already exists, a message box asks to confirm overwriting it.

Preview Table

The table includes fields for the From, To, Cc, and Bcc addresses, the subject, attachment file names, text message, and HTML message. An email blast may or may not have values for all of these fields, depending on its specifications.

See Also:

•	Email Blast Report

•	Previewing an Email Blast

•	Send Email to Screen

•	Send All Emails to This Email Address

•	Verifying Results

•	Verifying Data


Send All Emails to This Email Address

Select this option to send the sample emails to a specified email address. This email address is used instead of the email address in your data source. Sending the preview email to yourself is a great way to examine what the actual recipient sees.

Send Sample Emails to My Email Address

You can send the preview to multiple email addresses by separating them with commas:

Send Sample Messages to Email Addresses

Note that any Cc and Bcc addresses you specified in your email blast are ignored to prevent actual recipients from receiving your email. This applies to both standard and bulk mailings. To verify the To, Cc, and Bcc addresses, send the preview to the screen or table.

	When you send the email to an email address, your SMTP settings must be correct. See SMTP Settings for more information.
See Also:

•	Email Blast Report

•	Previewing an Email Blast

•	Send Email to Screen

•	Send Email to This Table

•	Verifying Results

•	Verifying Data


Verifying Results

Always take the time to verify your email. This should include checking the FROM address, subject line, attachments, and message text. You should also verify that all field references are properly replaced by field values.

See Also:

•	Email Blast Report

•	Previewing an Email Blast

•	Verifying Data


Verifying Data

In addition to previewing your email, you should verify the integrity of your data. This includes eliminating duplicate email addresses, removing bad or old email addresses, and making sure the data in the fields you reference is correct.

See Also:

•	Email Blast Report

•	Previewing an Email Blast

•	Verifying Results


Launching the Email Blast

After verifying that your messages preview properly and ensuring that your data is up-to-date, you’re ready to send your email blast! To start sending, select the email blast you want from the Main Menu and press the Send button [image]. The Send Wizard appears:

Email Blast Selection

The Email Blast Selection form displays a brief description and statistics of your selected email. You can either send the selected email blast, or choose several email blasts to send consecutively.

Sending a Single Email Blast

To send a single email blast, select "Send to the Currently Selected list:"

Review the list’s description, subject, table and statistics to ensure that the desired list is selected, and press the Next button [image] to select Send Options.

See Also:

•	Send Options

•	Status While Sending Messages

•	Sending Multiple Email Blasts

•	Viewing the Results


Send Options

The Send Options form allows you to specify who receives the email and to schedule or send the email blast:

Email Send Options

Recipients

Specify who should receive the email.

Entire List

Send to all email addresses in the source table.

Partial List Based on Audit Field

If the email blast has an Audit field that is cleared with every email blast, the second option is available. This allows Total Access Emailer to identify which records you have not sent this email to (records with a null value in the date/time audit field).

If the previous attempt to send the email blast was successful, or if the email blast was never run, this option says People Who Did Not Receive the Previous Email Blast. This lets you send email to new people on your list.

If the previous attempt to send the email blast failed (for instance, if the computer or network crashed or you canceled the email blast), the option says Restart Mailing Due to Previous Failure. This lets you pick up where you left off and send your email to those to whom it was not previously sent.

When the Partial List option is selected, the email blast is sent without clearing the Audit Field. As emails are sent, the Audit Field is updated for each record.

	This feature assumes the Audit Field was not modified except by the previous use of this email blast. To ensure that the Audit Field is accurate, you should not perform audit features during preview if you plan to resend email blasts to people who did not previously receive it.  If another email blast uses the same audit field, or if it is edited outside of Total Access Emailer, this feature may fail. In multi-user environments, you need to ensure other users have not modified this field.
Schedule

After selecting the recipients, select whether to start the email blast now, or schedule it for a later time.

Send Now

The email blast is launched as soon as you press [image].

Schedule for Later

This option is useful for sending a large email blast after hours when your mail server and network are less busy. Simply specify the date and time for sending the message:

Schedule Email Blast

After setting the schedule, press the Finish button [image] to schedule the email blast. The Send Options form remains open, and the email blast is launched at the specified time.

See Also:

•	Launching the Email Blast

•	Status While Sending Messages

•	Sending Multiple Email Blasts

•	Viewing the Results


Status While Sending Messages

While Total Access Emailer sends the email messages, it displays a dialog showing the current email address, how many email addresses are processed, and how many remain:

Processing Email Dialog

If there are a lot of emails, an estimated completion time is displayed after 30 messages are sent. The estimated time is updated as the messages are processed.

Canceling the Email Blast

You may cancel the email blast at any time by pressing Cancel. After canceling, the results form is displayed with information about how many messages were sent.

If your email blast includes an Audit Field that is cleared with each email blast, you have the option to resend to the email addresses that you missed. See Partial List Based on Audit Field for more information.

See Also:

•	Launching the Email Blast

•	Send Options

•	Sending Multiple Email Blasts

•	Viewing the Results


Sending Multiple Email Blasts

Total Access Emailer includes a powerful feature to send multiple email blasts back-to-back. To send multiple email blasts, select "Send to Multiple Lists" from the Email Selection List screen:

Then press the Next button [image] to go to the List Selection page.

Select Multiple Email Blasts

Use the List Selection page to select multiple email blasts to send consecutively:

List Selection Form

The top pane shows a list of all your email blasts. The bottom pane shows the ones you have selected to send and the order to send them. By default, the currently selected email blast is in this list. These buttons are available:

	Selects the currently selected email blast from the top list and moves it to the bottom.
	Removes the currently selected email blast from the bottom list and returns it to the top.
	Removes all the selected email blasts and returns them to the top list.
	Reorders the email blasts within the selected email blast list.
After selecting the email blasts to send, press the Next button [image] to select Send Options.

Send Options

The Send options are identical to the options for a single email list.

See Also:

•	Launching the Email Blast

•	Send Options

•	Status While Sending Messages

•	Viewing the Results


Viewing the Results

When the email blast(s) are complete, Total Access Emailer displays the results:

Email Blast Results

You can see some basic information about the email blast, including when it was started, when it finished, how many messages were sent, whether problems (errors) were encountered, and how many bad email addresses there are. Each row shows a separate email blast.

Restarting the Email Blast

If an email blast was interrupted for any reason, Total Access Emailer allows you to restart it, provided that you have enabled the Audit Field to clear and update a date/time field when each blast is sent. These email blasts have the [Restart Possible] column checked.

Press the Restart button [image] to send emails to these lists. When you restart these email blasts, Total Access Emailer sends the email only to people to whom it was not sent previously (recipients with a null value in the date/time audit field).

Results Report

Total Access Emailer provides a results report for the email blast. Press the Preview Report button [image] to preview and print the report.

Email Blast Results Report

This report prints in US Letter or A4 format, depending on the settings you selected on the Options form. To change the paper size, press the Options button [image] and modify the setting on the Report Options tab.

You can also reprint the report by clicking the Preview Last Email Blast Report button on the Report Options form.

Viewing Errors

If errors were encountered, a message appears informing you of the number of errors. The errors are stored in the table name you specified under Options:

Email Blast Errors Table

If the email address is invalid (i.e. the format is bad), the record shows the Email Blast ID, the date/time of the error, the error description ("Invalid Email"), and the bad address. For other errors, the record displays these fields in addition to the From, Cc, and Bcc addresses, and the email’s Subject, Attachments, and Text/HTML message.

If you configured the Email Options to overwrite the errors table, the table is overwritten with every email blast that encounters an error. If you did not configure the Email Options to overwrite the table, errors are appended to the existing table.

See Send and SMTP Options for more information.

See Also:

•	Launching the Email Blast

•	Send Options

•	Status While Sending Messages

•	Sending Multiple Email Blasts


How Total Access Emailer Works

Total Access Emailer is written in Microsoft Access, using its native Visual Basic for Applications (VBA) language with a combination of tables and forms, and some SMTP email libraries.

Tables

Total Access Emailer automatically saves your email blast settings for reuse. This information is stored in three hidden system tables in your database:

•	usysTEmailerOptions
Contains information about the Options Form. See Send and SMTP Options for details about these settings.

•	usysTEmailerSettings
Contains one record for each email blast, and holds the configurations specified in the Settings Editor. See Email Blast Overview for more information on the options stored in this table.

•	usysTEmailerEmbedded
Contains one record for each embedded Access object, and holds the configurations specified on the Embedded Object Specifications form. See Embedded Objects for details.

These tables are generally hidden and only appear in the database’s list of tables if you are viewing system objects. To see these tables, select Tools, Options from the Access menu. On the View tab of the options form, check "Show System Objects."

	Although you can edit the scenario tables, we strongly recommend that you do not do this directly. Use the Total Access Emailer Options Form and Settings Editor to modify the tables.
See Also:

•	How Total Access Emailer Works

•	Programmatic Interface

•	Distributing the Emailer File


Programmatic Interface

If you get the Professional Version of the Total Access Emailer or purchase the Runtime License after getting the Standard Version, a function is available to run email blasts programmatically. Easily add the power of email blasts to your Access applications and have them run at the touch of a button, or schedule the blast to run based on a trigger.

Any email blast created by the Settings Editor can be added to your application.

	This section describes the VBA interface to Total Access Emailer, and assumes that you are familiar with using VBA and invoking functions. If you are not, please refer to your Microsoft Access documentation.  Additionally, you should be familiar with using the Total Access Emailer Add-In to create email blasts before using these features. You must set up the email blast using the Add-In prior to calling it programmatically.
See Also:

•	Preparing Your Database

•	Calling the Emailer Function

•	Parameters

•	Limitations

•	Sample Code

•	Automating Multiple Email Blasts

•	Distributing the Emailer File


Preparing Your Database

To call the Total Access Emailer function, you need to create an explicit reference from your database to the library. To create this reference, open a module in design mode, and select Tools, References from the Access menu:

Access Library References

Make sure that "FMS Total Access Emailer" is selected. If this item does not appear in the list, use the Browse button [image] to locate the TAEmailR.mde library file in your installation directory.

The reference is an explicit path, which means that if you change the drive or location of the library, the reference is broken and the function will not compile.

You can programmatically add library references with the AddFromFile command. This example adds a reference to the file in the strFileName variable:

Dim ref as Reference

Set ref = References.AddFromFile(strFileName)

Refer to your VBA documentation for more information about reference commands.

More Information

•	Two Libraries for Access 2003

•	Important Note for Deploying to Access 2002 Users

See Also:

•	Programmatic Interface

•	Calling the Emailer Function

•	Parameters

•	Limitations

•	Sample Code


Two Libraries for Access 2003

Total Access Emailer for Access 2003 includes two library files: TAEmailR.mde and TAEmailR2K.mde. The file you select depends on the Access version(s) of your users.

TAEmailR.mde is a digitally signed database library in Access 2002/2003 format. It is designed for databases (in Access 2000 or 2002/2003 format) running under Access 2003 ONLY.

However, this file does not work for Access 2000 or 2002. If you use Access 2003 to create applications for Access 2000 and 2002 users, you need to reference the TAEmailR2K.mde library. This database is in Access 2000 format and is not digitally signed. The drawback is your Access 2003 users may receive a security warning when running your application (Access 2000 and 2002 users will not see this):

Access 2003 Security Warning

Determine which file to reference based on the Access version(s) your users run, or create two separate solutions: one for Access 2000/2002 and one for Access 2003.

See Also:

•	Preparing Your Database

•	Important Note for Deploying to Access 2002 Users


Important Note for Deploying to Access 2002 Users

If you’re sending emails with embedded objects in text format, and your application may be used by people running Access 2002, you must add an additional procedure to your database:

Public Function TotalAccessEmailer2002_Run( _
pintObjectType As Integer, pstrObjectName As String, _
pstrFormat As String, pstrOutputFile As String, _
pfAutoStart As Boolean, pstrTemplateFile As String) _
As String
' Copyright: Part of Total Access Emailer from FMS (www.fmsinc.com)
'            Copyright 2006 FMS, Inc.  All rights reserved.
' Comments : Used to work around an Access 2002 bug when exporting
'            embedded objects to text from an MDE.
'            Insert this in your Access application if you want to
'            use the Total Access Emailer programmatic interface
'            to automate your email blasts.
' Returns  : Error description, if any

Dim strError As String

On Error Resume Next

DoCmd.OutputTo pintObjectType, pstrObjectName, pstrFormat, _
pstrOutputFile, pfAutoStart, pstrTemplateFile

If Err.Number <> 0 Then
strError = Err.Number & "-" & Err.Description
End If

On Error GoTo 0

TotalAccessEmailer2002_Run = strError
End Function

This procedure is necessary to work around an Access 2002 error that occurs when exporting objects to text from an MDE file. Be sure to include this procedure if both of the following statements are true:

•	One or more of your email blasts include embedded tables, queries/views, or reports in text format (either as the text message or as an attachment); and

•	Any of your application users are running Access 2002 (Office XP).

	When you install Total Access Emailer, a file named Access2002Code.txt is written to your installation directory. This file contains the procedure above.
See Also:

•	Preparing Your Database

•	Two Libraries for Access 2003


Calling the Emailer Function

Total Access Emailer includes a special VBA function that is available to you when you reference the Total Access Emailer Runtime library (TAEmailR.mde):

Public Function TotalAccessEmailer(_
ByVal lngEmailID As Long, ByVal fRestartBlast As Boolean, _
ByVal strDisplayType As String, ByVal strDisplayTitle As String, _
ByVal fShowResults As Boolean, ByVal fShowErrors As Boolean, _
Optional ByVal pstrEmailTbl As String, _
Optional ByVal pstrOptionsTbl As String, _
Optional ByVal pstrEmbedTbl As String) _
As String

 To add this to your code, follow these steps:

1.	Ensure that Total Access Emailer is properly installed and referenced as a library database.

2.	Create the email blast in the database with the correct settings. Use the Preview Options to verify the settings.

3.	Determine the ID of the email blast that you want to send from code.

4.	Invoke the Total Access Emailer function.

Simply specify the scenario number to run, and pass some parameters to the function. The function returns the error string, or an empty string if the email blast ran without errors.

More Information

•	Parameters

See Also:

•	Programmatic Interface

•	Preparing Your Database

•	Two Libraries for Access 2003

•	Important Note for Deploying to Access 2002 Users

•	Limitations

•	Sample Code


Parameters

You can pass the following parameters to the Total Access Emailer function:

lngEmailID (long integer)

The ID of the email blast to send. This is the value in the ID column on the Main Menu of the Total Access Emailer add-in and in the [EmailID] field of the usysTEmailerSettings table.

fRestartBlast (boolean)

True (-1) to restart the email blast, or False (0) to start it from the beginning.

A value of True assumes the Audit Field feature to clear and update a date/time field is enabled. Only records with null (blank) values in the Audit Field are processed.

strDisplayType (string)

You can choose how to display the progress of the email blast to the user. Values include:

Setting	Description
"" (Empty string)	Progress is not displayed.
"Form"	Progress shows in a form, similar to the one shown Status While Sending Messages.
"StatusBar"	Progress shows in the Access Status bar in the lower left corner):
"StatusBarDesc"	In addition to the progress, the status bar shows the name of the Email blast that is currently running:
strDisplayTitle (string)

The title for the display form and any messages. If this is not provided, "Total Access Emailer" is used.

fShowResults (boolean)

True (-1) shows the email blast results in a message box:

Email Blast Results

fShowErrors (boolean)

True (-1) displays a message box if errors are encountered, for example:

Errors Message

If bad email addresses are encountered, the message box shows the number of bad emails, and opens the Errors table (if it exists):

Bad Email Addresses Message

False (0) still generates the errors table, but does not display a message or open the errors table.

	If you do not want the errors table to be generated, set the error table name to a blank value in your options table (the table specified by the strOptionsTbl parameter).
pstrEmailTbl (string)

The table in the database containing the email blast settings. The default value for this parameter is "usysTEmailerSettings" but you have the option to override this with another table name. This is particularly useful when you want to allow users to make modifications without affecting your original email blasts. Just make a copy of usysTEmailerSettings, and reference the new table name. If you don’t pass a parameter, "usysTEmailerSettings" is used.

pstrOptionsTbl (string)

The table in the database containing the Send and SMTP options. The default value for this parameter is "usysTEmailerOptions" but you have the option to override this with another table name. This is particularly useful when you want to allow users to make modifications without affecting your original settings. Just make a copy of usysTEmailerOptions, and reference the new table name. If you don’t pass a parameter, "usysTEmailerOptions" is used.

pstrEmbedTbl (string)

The table in the database containing the Embedded Object information. The default value for this parameter is "usysTEmailerEmbedded" but you have the option to override this with another table name. This is particularly useful when you want to allow users to make modifications without affecting your original settings. Just make a copy of usysTEmailerEmbedded, and reference the new table name. If you don’t pass a parameter, "usysTEmailerEmbedded" is used.

Return Value

The function returns an empty string if the email blast ran without errors, or the error string. The error string is what's displayed if fShowErrors is True. It could be the number of bad emails, or a more serious problem with the email blast specifications or data source, network, hardware, SMTP server, etc. If fShowErrors is set to False, you should display this information to your user.

See Also:

•	Programmatic Interface

•	Preparing Your Database

•	Two Libraries for Access 2003

•	Important Note for Deploying to Access 2002 Users

•	Calling the Emailer Function

•	Limitations

•	Sample Code


Limitations

When you run email blasts programmatically, Total Access Emailer performs significantly less error checking than the interactive interface. Please be aware of the following limitations before invoking the Total Access Emailer function:

•	The Total Access Emailer function assumes that the email blast settings are correct. If you edit the tables directly, you are responsible for making sure you enter the right values. We highly recommend that you use the interactive interface to edit email blast settings to avoid entering bad data.

•	Total Access Emailer assumes the data source is available. If it is not, the email blast fails.

•	Total Access Emailer assumes that all database security rights (ability to read the data source, and create auditing and error tables if necessary) are granted.

See Also:

•	Programmatic Interface

•	Preparing Your Database

•	Two Libraries for Access 2003

•	Important Note for Deploying to Access 2002 Users

•	Calling the Emailer Function

•	Parameters

•	Sample Code


Sample Code

The Total Access Emailer sample database, which is in your installation directory, includes sample code for running email blasts programmatically. The code is located in the form module frmProgrammaticSample :

Private Sub btnSendMonthlyNewsletter_Click()
' Comments: Send Monthly Newsletter

Dim strError As String
strError = TotalAccessEmailer(1, False, "Form", _
"", True, True)

End Sub

Example of Calling the Total Access Emailer Function

In this example, email blast number 1 is being sent.

Remember that for this sample to function properly, Total Access Emailer must be loaded as a library in the Access Tools, References menu.

See Also:

•	Programmatic Interface

•	Preparing Your Database

•	Two Libraries for Access 2003

•	Important Note for Deploying to Access 2002 Users

•	Calling the Emailer Function

•	Parameters

•	Limitations


Automating Multiple Email Blasts

In some cases, you may need to send multiple related messages consecutively. For instance, you may need to send a confirmation message to all new records in your Orders table, and a separate notification message to records in a query that shows all items on backorder.

To send multiple consecutive emails programmatically, you should generally pass the following parameter values:

•	If you are running the same email blast to notify "new" recipients, you should have the fRestartBlast parameter in your procedure call set to TRUE (-1). If you are sending to the entire list, use FALSE (0).

•	Set fShowResults to FALSE (0). If set to TRUE (-1), the results display requires user interaction before processing the next email blast.

•	Set fShowErrors to FALSE (0). If set to TRUE (-1), the errors display requires user interaction before continuing processing.

Public Function SendNewsletters()
  ' Comments: Send 2 newsletters consecutively.

  Dim strError As String

  strError = TotalAccessEmailer(1, False, _
            "Form", "", False, False)
  If strError = "" Then
            strError = TotalAccessEmailer (1, False, _
            "Form", "", False, False)
  End If

  SendNewsletters = strErrMsg

End Function

An example of automating multiple email blasts is included in the sample database, in the modEmailBlasts module.

For a detailed list of all parameters, see Parameters.

See Also:

•	Programmatic Interface

•	Running Email Blasts from a Macro

•	Scheduling Emails with Total Visual Agent

•	Distributing the Emailer File


Running Email Blasts from a Macro

If you need to schedule email blasts to run on a regular basis, consider creating a macro that runs the email blasts, and using an automated scheduling tool to run the macro. To create a macro that runs the email blasts, follow these steps:

1.	Create a new public function that runs the email blasts, as explained in Calling the Emailer Function.

2.	Create a new macro, and add the macro action "RunCode."

3.	In the Function field, specify the name of the function you specified in Step 1. For instance, if your function is named "SendToSubscribers", your macro should look like this:

Example of Running Email Blasts from a Macro

4.	Use an automated scheduling tool to run the macro at the desired intervals.

The Total Access Emailer sample database includes an example of running email blasts from a macro in the RunEmailBlasts macro.

See Also:

•	Programmatic Interface

•	Automating Multiple Email Blasts

•	Scheduling Emails with Total Visual Agent

•	Distributing the Emailer File


Scheduling Email Blasts with Total Visual Agent
Scheduling Emails with Total Visual Agent

There may be times when you need to send an email on a regular basis. For instance, you may want to send a two daily confirmation emails: a newsletter to new people in your "Subscribers" table, and a confirmation to new people in your "Orders" table.

Total Visual Agent from FMS allows you to schedule a macro to run multiple times per hour, hourly, daily, weekly, monthly, or on a one-time basis. Schedule Total Visual Agent to run all your email blasts automatically:

•	Every 10 minutes, send a confirmation email to new records in your Orders table.

•	Every hour, send an email to instruct new customers to download their software.

•	Every day, send an email to new newsletter subscribers.

•	Every week, send an email to employees reminding them to turn in their timesheets.

•	Every month, email an invoice to all clients.

In addition to running macros, Total Visual Agent automates database maintenance tasks (such as backups, compacting, and repairing). Visit our web site, www.fmsinc.com, to find out more about this product and to download a 30-day fully functional trial.

	You can find the Total Visual Agent trial, as well as trials and demos of other FMS products, right on your Total Access Emailer CD.
See Also:

•	Programmatic Interface

•	Automating Multiple Email Blasts

•	Running Email Blasts from a Macro

•	Distributing the Emailer File


Licensing Rules

The Runtime License of Total Access Emailer gives you a royalty-free license for you to distribute your application with our email functionality to non-owners of Total Access Emailer. You must agree to the terms of the license agreement prior to using or distributing Total Access Emailer functionality. You may not distribute the Total Access Emailer license file, or distribute the program in any way that allows users to create their own email blasts.

You may not include the Total Access Emailer Add-In functionality or the Settings Editor, and you may not build an application that emulates the Total Access Emailer user interface. See the License Agreement for complete licensing details.

You are only allowed to distribute the runtime Emailer file (TAEmailR.mde) and associated DLLs. To handle this, Total Access Emailer includes a small executable that distributes the necessary runtime files to your user’s system.

	FMS does not provide technical support or customer service to your application’s users. We can only provide technical support to you as the registered user of the product (the developer).
See Also:

•	License Agreement

•	Programmatic Interface

•	Distributing the Emailer File

•	Running Multiple Programs from Your Setup Program

•	Troubleshooting Tips


Distributing the Emailer File

In order to allow Access to use Total Access Emailer functionality, the program must be registered on the local machine. When you install Total Access Emailer on your development computer, the Setup program handles this automatically.

When you distribute your application to your users, however, they do not have the Setup program. To distribute your application with Total Access Emailer functionality, you must install the redistributable component on your user’s machine.

Using the Runtime Install Program

Total Access Emailer includes a runtime distribution program, TAERunVer.exe (where Ver is the version of Total Access Emailer). This file is located in your installation directory. All you need to do is execute TAERun.exe on your users’ machines, and they’re ready to use your application.

This executable distributes the necessary runtime files to your users’ systems and configures their computers to use Total Access Emailer in runtime mode.

See Also:

•	License Agreement

•	Programmatic Interface

•	Licensing Rules

•	Using the Microsoft Office Package Wizard

•	Running Multiple Programs from Your Setup Program

•	Troubleshooting Tips


Using the Microsoft Office Package Wizard

Using the Package Wizard in Microsoft Office Access 2003 Developer Extensions

If you are using the Package Wizard in Microsoft Office Access 2003 Developer Extensions, follow these steps to ensure that Total Access Emailer is configured correctly:

•	In the list of Additional Files, click "Add" and choose TAERunVer.exe (where Ver is the version of Total Access Emailer). This file is located in your installation directory.

Do not distribute TAEmailR.mde. This file is distributed and registered when your setup runs TAERun.exe.

•	After the setup is created, open the file:
     \\SetupPath\Files\Setup\Setup.ini
(Where SetupPath is the directory where you created the setup.)

Append the following to the end of the Setup.ini file:
      [ChainedInstall_1]
     Path="\Files\TAERunVer.EXE"
     TaskType=EXE
     CmdLine=
(Where Ver is the version of Total Access Emailer.)

For more information, please refer to the documentation that Microsoft Office Access 2003 Developer Extensions.

Using the Packaging Wizard in the Microsoft Office XP Developer Toolkit

If you are using the Packaging Wizard in the Office XP Developer Toolkit, follow these steps to ensure that Total Access Emailer is configured correctly:

•	In the list of included files, uncheck TAEmailR.mde. This file is distributed and registered when your setup runs TAERun.exe.

•	In the list of included files, select "Add" and choose TAERun.exe. This file is located in your installation directory.

•	On the Installation Options page, check "Run this command when installation is finished," and type "TAERunVer.exe" (where Ver is the version of Total Access Emailer).

For more information, please refer to the documentation that accompanies Microsoft Office XP Developer.

Using the Package and Deployment Wizard in the Microsoft Office 2000 Developer Toolkit

If you are using the Package and Deployment Wizard in Office 2000 Developer, follow these steps to ensure that Total Access Emailer is configured correctly:

•	In the list of included files, uncheck TAEmailR.mde. This file is distributed and registered when your setup runs TAERun.exe.

•	In the list of included files, select "Add" and choose TAERun.exe. This file is located in your installation directory.

•	On the Installation Options page, check "Run this command when installation is finished," and type "TAERunVer.exe" (where Ver is the version of Total Access Emailer).

For more information, please refer to the documentation that accompanies Microsoft Office Developer 2000.

Using the Setup Wizard in the Office 97 Developers Edition Toolkit

If you are using the Setup Wizard in the Office 97 Developers Edition (ODE) to distribute your application, setup is fairly easy. When the Setup Wizard displays the option to run an executable after setup has completed, select TAERun.exe (located in your installation directory). Make sure you select the check box titled "Allow Setup to Complete Before the File Finishes Running."

For more information, refer to the documentation that accompanies the ODE.

See Also:

•	Contacting Technical Support

•	Programmatic Interface

•	Licensing Rules

•	Distributing the Emailer File

•	Running Multiple Programs from Your Setup Program

•	Troubleshooting Tips


Running Multiple Programs from Your Setup Program

If you use the setup tools included with Microsoft Office, you will find that these tools only allow you to run a single external program as part of your setup. If the only external program you need to run is the Total Access Emailer deployment program (TAERun.exe), this limitation causes no problems. However, if your setup needs to run external programs in addition to TAERun.exe, you need to take additional steps.

We suggest using an MSDOS batch file to run multiple external programs. Basically, your setup program calls the batch file that contains multiple commands to run the actual external programs you need. To do this:

1.	Create a batch file that calls each external executable program that your application’s setup needs to run.

2.	Test this batch file on your system to ensure it works as desired.

3.	Include the external executables in your setup program.

4.	Include the batch file in your setup program.

5.	Specify the name of the batch file in the Package and Deployment Wizard/Packaging Wizard as the external program to run.

Creating a Batch File

To create a batch file that executes multiple programs, follow these steps:

1.	Create a new text document with a text editor such as Windows NotePad.

2.	Add a line that calls the TAERun.exe program. Include the full path to the file.

	To ensure your batch file runs correctly on the widest variety of Windows platforms, be sure to shorten any long file names or long path names to their DOS 8.3 equivalents. For example, if TAERUN.EXE is located in: C:\Windows\Temporary Files\TAERUN.EXE Then your batch file should call it as C:\Windows\Tempor~1\TAERUN.EXE To determine the actual DOS 8.3 equivalent of a long file or path name, open an MSDOS window, change your directory to the location of the file, and issue the Dir command. This command will list the DOS 8.3 representation of any long file or path name.
3.	Type in additional lines to call the other external programs you need to run. As with the TAERun.exe program, consider shortening long file or path names to their DOS 8.3 equivalents.

4.	You may also want to include the following command:

@ECHO OFF

As the first line in your batch file to instruct Windows to run the executable files without displaying any characters in the DOS window.

You can also include comments by typing REM at the start of the line.

5.	Save this file as Filename.BAT (where Filename is the name you chose for your batch file). Note that if you do not use the .BAT file extension, Windows will not be able to execute it.

A sample batch file would look like this:

  @ECHO OFF
  REM My batch file for distributing Total
  REM Access Emailer and other external
  REM programs that my application needs.

  REM Install Total Access Emailer
  C:\Windows\Tempor~1\TAERUN.EXE

  REM Install SuperWidget 9000
  C:\Windows\Tempor~1\SUPERW.EXE

  REM Install Font Program
  C:\Windows\Tempor~1\FONT.EXE

See Also:

•	License Agreement

•	Programmatic Interface

•	Licensing Rules

•	Distributing the Emailer File

•	Using the Microsoft Office Package Wizard

•	Troubleshooting Tips


Troubleshooting Tips

If your distributed application is not functioning properly, please ensure that:

•	The Server Settings have been configured properly for your user’s mail server. By default, the Server Settings are located in the usysTEmailerOptions table.

•	The Total Access Emailer Library Database is properly referenced. To verify this, view any module, and select Tools, References from the menu. Ensure that "Total Access Emailer" is referenced, and that it is not listed as "Missing." If it is not referenced, use the Browse button:  to locate the TAEmailR.mde library file on the local machine.

If these troubleshooting tips do not resolve your problem, refer to Technical Support Options for information about obtaining Technical Support.

See Also:

•	Contacting Technical Support

•	Programmatic Interface

•	Licensing Rules

•	Distributing the Emailer File

•	Using the Microsoft Office Package Wizard

•	Running Multiple Programs from Your Setup Program


Support Resources

There are many resources available to help you resolve issues you may encounter. Please check the following:

Readme File

Check the README file for the latest product information. The README file is located in the directory where you installed the product.

Product Documentation

We’ve spent a great deal of care and time to make sure the Total Access Emailer manual and help file are very detailed. Check the Table of Contents and Index for your question, and read the appropriate pages.

See Also:

•	Web Site Support

•	Technical Support Options

•	Contacting Technical Support


Web Site Support

The FMS web site contains extensive resources to help you use our products better. Resources include product updates, frequently asked questions (FAQs), newsgroups, information on new versions, betas, and other resources.

Home Page

The FMS web site is located at:

www.fmsinc.com

News and important announcements are posted here.

Support Site

The main support page is located at:

www.fmsinc.com/support

From this page, you can quickly locate the other support resources.

Product Updates

FMS takes product quality very seriously. When bugs are reported and we can fix them, we make the updates available on our web site. If you are encountering problems with our product, make sure you are using the latest version.

Product updates can also be checked using the update wizard.

Frequently Asked Questions (FAQs)

Common questions and additional information beyond what is in the manual is often available from our FAQs.

Newsgroups

FMS also has general and product specific newsgroups. Connect with FMS Technical Support and other users there. Share your experiences, learn from others, and ask your questions in our virtual community:

www.fmsinc.com/support/newsgrp.htm

Or visit our web site for additional information.

Microsoft Patches

Our support site also includes links to Microsoft patches that are related to our products. Make sure you’re using the latest versions by checking here or visiting the Microsoft site.

See Also:

•	Support Resources

•	Technical Support Options

•	Contacting Technical Support


Technical Support Options

FMS is committed to providing professional support for all of our products. We offer free access to our online FAQs and newsgroups. Bug reports, feature requests, suggestions, and general pre-sales questions related to our products are always available at no cost.

Additional maintenance plans are available to provide subscribers with enhanced technical support. This is the best way for you to stay current with the rapidly changing technologies that impact project development, and to ensure you are getting the maximum return from your software investment. Please visit our web site, www.fmsinc.com, for the most up-to-date information.

Features & Benefits	Premium	Incident	Standard
Access to FAQs
Access to Newsgroups
Minor Upgrades/ Bug Fixes
Telephone Support		Per  incident	First 30  Days
Email Support		Per  incident	First 30  Days
Priority Response Time (1)
Senior Engineer Support Team
Email Project for Testing
Programmatic Code Assistance (2)
Major Upgrades for Current Version (not between Access versions)		Additional Fee	Additional Fee
Cost	Annual Fee	Fee Per  Incident	Included

1.	Response generally within two business days. Actual resolution may take longer depending on complexity of the issue reported.

2.	Custom Programming implementation is not provided in our Support Maintenance plans. For products that include a programmatic interface, we can provide instructions for using our programmatic interface, and show examples, but we do not implement this into your projects. This service is available from our Professional Solutions Group.

Premium Subscription

The Premium Subscription is the ideal option for customers seeking the highest level of support from FMS. The annual fee entitles you to telephone and email technical support from a senior support engineer.

From time to time, FMS may release new versions of existing products which add new features. These are point releases (e.g. from version 11.0 to 11.1) and are different from new builds that correct problems in existing features (e.g. from version 11.00.0001 to 11.00.0002).

These point releases are available for a nominal upgrade fee to existing customers. Premium Technical Support subscribers receive these upgrades automatically and for no additional charge during their subscription term.

NOTE: Upgrades between versions (for instance going from Access 2002 to Access 2003) are not considered Point Release Upgrades and are not included in the Premium Subscription.

Subscriptions are available for a twelve month period, and may be purchased at any time. You must be the registered owner of the product to purchase a subscription and the only person contacting FMS for support under the subscription.

Please ensure you have purchased the Subscription you need for Total Access Emailer.

Per Incident

Our Per Incident package is available individually or by purchasing multiple incidents in advance. The Per Incident support package provides telephone and email technical support from a Senior Technical Support Engineer for resolving one incident.

An incident is defined as a single question related to one of our products. The Per Incident period is from start to finish (report of the incident to resolution) for a single incident. If you anticipate multiple questions for a single product, we recommend purchasing the Premium Subscription.

Standard Subscription

Our Standard Subscription comes with every product purchased for no additional cost. The standard subscription comes with access to our FAQs and newsgroups, and responses to bug reports and feature requests for that version.

Please note that the person requesting support must also be the registered user of the product. Registration is required and will be requested by our Technical Support professionals.

See Also:

•	Support Resources

•	Web Site Support

•	Contacting Technical Support


Contacting Technical Support

If the troubleshooting suggestions and other support resources fail to resolve your problem, please contact our technical support department. We are very interested in making sure you are satisfied with our product.

Registering Your Software

Please register your copy of Total Access Emailer at:

www.fmsinc.com/support

You must be registered to receive technical support. Registration also entitles you to free product updates, notifications, information about upcoming products, and beta invitations. You can even receive free email notification of our latest news.

Contact Us

The best way to contact us is via email at:

Support@fmsinc.com

Please provide detailed information about the problem that you are encountering. This should include the name and version of the product, your operating system, and the specific problem. If the product generated an error file, please submit that as well.

With email, technical support issues can be more accurately resolved and tracked in our internal technical support system. Email also gives us more time to understand the entire problem and allows our technical support staff to contact the developers with the entire story when necessary. Please bear in mind that a unique issue may involve meetings between the technical support staff and product developers, so your patience is appreciated.

Microsoft Technical Support

FMS only provides technical support for its products. If you have questions regarding Microsoft products, please contact Microsoft technical support.

See Also:

•	Support Resources

•	Web Site Support

•	Technical Support Options


License Agreement

PLEASE READ THE FMS SOFTWARE LICENSE AGREEMENT. YOU MUST AGREE TO BE BOUND BY THE TERMS OF THIS AGREEMENT BEFORE YOU CAN INSTALL OR USE THE SOFTWARE.

IF YOU DO NOT ACCEPT THE TERMS OF THE LICENSE AGREEMENT FOR THIS OR ANY FMS SOFTWARE PRODUCT, YOU MAY NOT INSTALL OR USE THE SOFTWARE. YOU SHOULD PROMPTLY RETURN ANY FMS SOFTWARE PRODUCT FOR WHICH YOU ARE UNWILLING OR UNABLE TO AGREE TO THE TERMS OF THE FMS SOFTWARE LICENSE AGREEMENT FOR A REFUND OF THE PURCHASE PRICE

Ownership of the Software

The enclosed software program ("SOFTWARE") and the accompanying written materials are owned by FMS, Inc. or its suppliers and are protected by United States copyright laws, by laws of other nations, and by international treaties. You must treat the SOFTWARE like any other copyrighted material except that you may make one copy of the SOFTWARE solely for backup or archival purpose, and you may transfer the SOFTWARE to a permanent storage device.

Grant of License

The SOFTWARE is available in a Standard Version and a Professional Version. The Professional Version includes a programmatic interface and Runtime License.

The SOFTWARE is available on a per license basis. Licenses are granted on a PER USER basis. For each license, one designated person can use the SOFTWARE on one computer at a time.

Use and Redistribution Rights

This SOFTWARE license is for one user only.

A Runtime License can be purchased as part of the Professional Version or as a separate license after the purchase of the Standard Version. The Runtime License grants limited redistribution rights. The Runtime Library Database is available distribute applications that use the email settings created with Total Access Emailer. The Runtime License provides the non-exclusive, royalty-free right to incorporate email blasts from Total Access Emailer in your applications, provided that:

1.	Each developer using the SOFTWARE owns a Runtime License.

2.	Your application adds substantial value to the SOFTWARE and is not a standalone email program.

3.	Your application does not attempt to replicate the interactive user interface of the SOFTWARE.

4.	Your application is not a freeware or shareware product.

5.	You only distribute the designated redistributable files and no other files of the SOFTWARE.

6.	If you claim a copyright, you must add a clause stating "Portions of this program are copyright Total Access Emailer from FMS, Inc.", and do not claim ownership of the SOFTWARE.

7.	You agree to indemnify, hold harmless, and defend FMS and its suppliers or contractors from and against any claims or lawsuits, including attorneys’ fees, which arise or result from the use or distribution or other activities relating to your applications.

Other Limitations

Under no circumstances may you attempt to reverse engineer this product. You may not rent or lease the SOFTWARE, but you may transfer the SOFTWARE and the accompanying written materials on a permanent basis provided you retain no copies and the recipient agrees to the terms in this SOFTWARE License. Ownership transfers must be reported to FMS, Inc. in writing and are not accepted if the original developer already distributed applications using the SOFTWARE.

Transfer of License

If your SOFTWARE is marked, "NOT FOR RESALE," you may not sell or resell the SOFTWARE, nor may you transfer the FMS Software license.

If your SOFTWARE is not marked, "NOT FOR RESALE," you may transfer your license of the SOFTWARE to another user or entity provided that:

1.	You have not distributed applications including the SOFTWARE with the Runtime License.

2.	The recipient agrees to all terms of the FMS Software License Agreement.

3.	You provide all original materials including software disks or compact disks, and any other part of the SOFTWARE’s physical distribution to the recipient.

4.	You remove all installations of the SOFTWARE.

5.	You notify FMS, in writing, of the ownership transfer.

Limited Warranty

If you discover physical defects in the media on which this SOFTWARE is distributed, or in the related manual, FMS, Inc. will replace the media or manual at no charge to you, provided you return the item(s) within 60 days after purchase.

ALL IMPLIED WARRANTIES ON THE MEDIA AND MANUAL, INCLUDING IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE LIMITED TO SIXTY (60) DAYS FROM THE DATE OF PURCHASE OF THIS PRODUCT.

Although FMS, Inc. has tested this program and reviewed the documentation, FMS, Inc. makes no warranty or representation, either expressed or implied, with respect to this SOFTWARE, its quality, performance, merchantability, or fitness for a particular purpose. As a result, this SOFTWARE is licensed "AS-IS", and you are assuming the entire risk as to its quality and performance.

IN NO EVENT WILL FMS, INC. BE LIABLE FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES RESULTING FROM THE USE, OR INABILITY TO USE THIS SOFTWARE OR ITS DOCUMENTATION.

THE WARRANTY AND REMEDIES SET FORTH IN THIS LIMITED WARRANTY ARE EXCLUSIVE AND IN LIEU OF ALL OTHERS, ORAL OR WRITTEN, EXPRESSED OR IMPLIED.

Some states do not allow the exclusion or limitation of implied warrantees or liability for incidental or consequential damages, so the above limitations or exclusions may not apply to you. This warranty gives you specific legal rights; you may also have other rights that vary from state to state.

U.S. Government Restricted Rights

The SOFTWARE and documentation are provided with RESTRICTED RIGHTS. Use, duplication, or disclosure by the Government is subject to restrictions as set forth in subparagraph (c) (1) (ii) of the Rights in Technical Data and Computer Software clause at DFARS 252.227-7013 or subparagraphs (c) (1) and (2) of the Commercial Computer Software - Restricted Rights at 48 CFR 52.227-19, as applicable.

Manufacturer is FMS Inc., Vienna, Virginia.
Printed in the USA.

Total Access Emailer is copyright ©1994-2006 by Financial Modeling Specialists, Inc.
All rights reserved.
Microsoft, Microsoft Access, Microsoft Windows, and Visual Basic are registered trademarks of Microsoft Corporation.
All other trademarks are trademarks of their respective owners.