Mail Merge Sources

You can create mail merge data sources quickly and easily for integration directly into word processors and spreadsheet applications. From these applications you can then print off bulk letters or save individual document files. Mail merge sources generate CSV files to perform this integration. They can also generate PDF files for sheets of printable labels and send bulk emails.

Running a Mail Merge

To run a mail merge, navigate to the Mail top level menu.

Initially, ASM does not come preloaded with any, however you can install mail merge sources from Settings ‣ Reports ‣ Browse sheltermanager.com (they appear in the list with the type “Mail Merge”).

_images/merge_source.png

When executing a mail merge, you will be prompted to create a CSV file, print some labels, generate documents or send bulk emails. You will want to create a CSV file if you intend to use a wordprocessor to create printed letters or view the output with a spreadsheet program.

The files are always named <source>.csv (CSV is a text-based file of comma separated values). The mail merge tool will prompt you for a location to save the file to.

Printing Labels

ASM can generate sheets of labels for your printer. It has a list of some popular label manufacturers and sizes, or you can enter the paper size and measurements from the back of the box of labels that you have. Hitting Download will send a PDF to your computer with all the addresses laid out for the labels and ready to print. Most modern web browsers can render and print PDF files directly.

Generating Documents

ASM can generate documents (such as form letters) for every result in the mail merge. Select a template from the list under the “Generate documents” slider and that template will be run for each row in the mail merge results and output into a continuous document with page breaks between each one.

Unlike the documents generated by the document button on the animal or person toolbars, document templates that you use with mail merges can only see the columns in the mail merge data.

Each column can be accessed from your template with <<ColumnName>>. The only other wordkeys available are the organisation keys listed under Appendix: Wordkeys

For example, if your mail merge returns the fields OwnerName, OwnerAddress, OwnerTown, OwnerCounty, OwnerPostcode, then your template should contain <<OwnerName>>, <<OwnerAddress>>, <<OwnerTown>>, <<OwnerCounty>> and <<OwnerPostcode>> to access them.

Bulk Email

_images/mail_email.png

In addition, Animal Shelter Manager allows you to bulk email any mail merge source directly.

ASM needs outbound email configured to use this option, which can be configured under Settings ‣ Options ‣ Email.

All of the mail merge sources you can install from sheltermanager.com will honour the “Exclude From Bulk Email” and “Deceased” person flags to prevent you emailing people who do not want mass emails or are no longer with us.

In the merge screen, you can expand the email panel to send emails. It contains ASM’s own internal email client with a list of tokens available so you can customise the email for each individual user.

_images/mail_labels.png

Integrating with OpenOffice

These instructions apply to versions 1.x and upwards of OpenOffice. To integrate your CSV merge source with OpenOffice, you will need to register it as a data source. Open a new, empty document in OpenOffice and click on the Tools menu. Now click on “Data Sources” to bring up the list of known data sources.

Enter the name first - you may call it anything you like, however for ease, use the name of the source in Animal Shelter Manager. For the type, select “Spreadsheet” from the drop down box. Click the browse button below to pop up an open dialog. You should then find the csv file you downloaded and select it.

Now, click on the tables tab. You will be prompted with the OpenOffice text convert screen. OpenOffice is intelligent enough to understand csv files and you can safely click the Ok button in the top right corner.

You will be returned to the data source manager screen. Simply click Ok now as you have successfully set up your mail data source.

Create the OpenOffice Document

Now that your source is set up, you can create as many different documents as you like within OpenOffice to utilise them.

Create a new document, or open an existing one you would like to adapt. Pull down the “Insert” menu and select “Fields”, followed by “Other”.

Select the “Database” tab and highlight “Form Letter Field” on the left. You should now see all your data sources on the right in tree form. Expand the one you would like to use, and simply double click on fields to embed the placeholders in your document (these placeholders will be replaced with real data when you run the merge).

TIP: While this screen is open, double-click ALL the fields you intend to use and then move them around in your document later. This is much easier than coming back to this screen repeatedly for each field.

Run the Merge

Once you have a document that you are happy with, make sure it is saved. To run the merge, bring up the data sources window by pressing F4 on the keyboard. Your datasources will be listed down the left hand side. Expand the one you want to use (you may be prompted for the text import again - simply click Ok). Expand the Tables section and highlight “Sheet1”. Your data will be displayed on the right hand side.

To initiate a merge, click on the “Form Letter” button. It appears on the data toolbar second from the right and looks like three envelopes stuck together.

You may now choose how to merge. You can write emails (by selecting “Electronic” and selecting “Email” as the field). Generate printed documents by using the printer, or generate individual copies of this document for each entry by selecting “File”.

Integrating with Microsoft Word

These instructions apply to versions 6.0, 95, 97, 2000 and XP of Microsoft Word. To integrate your mail merge source with Microsoft Word, simply open Word with an empty new document. Pull down the Tools menu and select “Mail Merge”. Word allocates data sources per document (as opposed to OpenOffice, which allocates data sources applicable to all documents).

Word will now prompt you through a three-step process, where you must either open an existing document or turn the current document into a mail merge document (you may choose from Form Letters, Address Labels etc.)

Step two prompts you to get the data source - simply find the csv file you download and select it.

Note

Note that by default Word will not show the csv files in its dialog - make sure you drop down the file type list and select “All Files (.)”

If you used an empty document, Word will prompt you to select mail merge fields to use. You can insert these placeholders into your document by dropping down the “Insert Merge Field” button that has appeared on the merge toolbar.

When you are happy, make sure you save your document. To run the merge, go back to Tools ‣ Mail Merge and select “Merge” under step 3.

Word will generate a new document containing a new copy of your original document for each entry in the data for you to print and save.

The Word document you have created will always rely on your data source, so should you change it (generate a new one from Animal Shelter Manager), you can simply open the document again and rerun the merge.