Contact us Blog

Document and Email Generation

Apsona's Document and Email Generator add-on lets you produce pixel-perfect Word, Excel or PDF documents or personalized email messages directly from your Salesforce data in one click.

Watch a demo

"I hadn't really gotten into your merge tool until recently, and I was testing several other apps at the same time. I found yours to be the easiest, simplest, and no-frills in a really good way that I think will allow my clients a quicker learning curve. So, thanks!"
– Amy Martin, Consultant

Common use cases

How it works

  1. Create a template

    Use familiar Word or Excel tools to create a template with placeholders, and upload to Salesforce
  2. Map your data

    Select data source (native or custom object or report) and match its fields with the placeholders
  3. Generate documents

    Run the merge action to generate documents/email

Key features

More detailed information about email and document merge is available in our help section.

Comparison with similar products

Apsona Document GeneratorConga Composer
Generate Word (.docx) documents
Address labels
Generate Excel (.xlsx) documents
Generate PDF documents
Generate Powerpoint documents
Supports both native and custom Salesforce objects
Generate email messages Included Additional cost (Conga Courier)
Bulk document generation (documents for multiple records in one run) Included Additional cost (Conga Conductor)
Email can contain a list (e.g., invoice containing list of items purchased)
Email from custom domains
Documents generated entirely within the browser Yes (except PDFs) No (uses third-party service)
Excel documents support pivot tables and pivot charts
Pricing basis Single flat fee Per-unit cost based on number of documents/emails generated
Max rows per report Unlimited 2,500
Max number of sub-lists Unlimited 50
Max generated document size Unlimited (depends only on your computer's memory) 40 MB
Max size of template file 2 MB (recommended) 10 MB
Can send scheduled email
Graphical (WYSIWYG) email template editor

Common questions

What does the tool do?
The Document Generator add-on lets you produce a wide range of documents from your Salesforce data:
  • Excel generation: Generate an Excel spreadsheet from an Excel .xlsx template, containing data from one or more Salesforce objects or Apsona reports or multi-step reports.
  • Email generation: Generate one or more personalized email messages from an email template, and send off the email messages.
  • Document generation: Generate a batch of .docx or .pdf files from a .docx template, and download the results either as a .zip file or as a single .docx file with many pages, one for each record.
  • Address labels: Generate a list of address labels using standard or custom stationery, with addresses from your Salesforce database.
  • Email and document generation: Use a specified email template and a specified document template to generate a batch of email messages and documents, attach each resulting document to the corresponding email, and send off the emails.
  • One-click merge/mail: Set up a button in a detail page of your Salesforce system, so that clicking the button will generate the result of merging that data record with your template.
In all of these cases, the data to be merged into the template can be obtained either from an Apsona report, including cross-object reports, or from the records in any of the Salesforce objects via Apsona's console or tabular views.
Can I merge data from custom objects or fields?
Yes, Apsona includes complete support for both native and custom objects.
Does Apsona's merge tool rely on Salesforce's mail merge features?
Salesforce provides a merge feature that relies on Internet Explorer, as well as a feature called extended merge. The Apsona tool does not require any of these features.
What browsers and operating systems are supported?
Apsona's merge tool works best with Google Chrome, Mozilla Firefox and Microsoft Edge. It is supported on Windows, Mac and Linux platforms, and works with Microsoft Office (versions 2007 or later), OpenOffice or LibreOffice software, or Google Docs.
What email provider does it use?
The email component of the merging tool uses Salesforce's built-in single-email-messaging service. Currently, this service limits you to a maximum of 5,000 email messages per day. If you need larger email message volume, you might consider our Email Connector product.
What about data privacy and security? How does it work in that regard?
When you generate a Word or Excel document with the Apsona tool, your data never leaves your Salesforce org. All data traffic happens between your browser and the Salesforce database using the Secure Sockets Layer connection, and the document is generated entirely within your browser. There is no third-party service involved. This architecture is quite different from other document generation tools on AppExchange (such as Conga or Drawloop), which need to transmit your data to their servers in order to prepare the documents. This architecture also enables Apsona to generate and deliver documents much more quickly than other products.

When you generate a PDF file, however, we have to make an exception. Unfortunately, there is no easy way to convert a Word or Excel document to PDF format entirely within the browser. For this reason, PDF conversion relies on an external service that we provide. However, we ensure that the data transmitted to this service is limited to the content of the generated Word document, and nothing else. And, of course, that the communication happens entirely over the Secure Sockets Layer, with safeguards in place to guard against cross-site scripting and similar attacks.

What templates can it use?
For email templates, the merging tool can use any of the templates stored in your salesforce org, i.e., the ones accessible via Setup - Communication Templates - Email Templates. For document templates, the merging tool can use any .docx or .xlsx files available in your Salesforce Documents object.
What does it cost?
Please visit our pricing page for details.
How do I get it?
Please contact us for a trial. Alternatively, in your Apsona app within your Salesforce org, click the Feedback link on the top right, and in the resulting popup, select "License request". Fill in a bit of text (e.g., "I want to try mail merge") and click Send. This will also tell us the org id and your user id, and make it easier for us to set up your trial. If you don't already have Apsona for Salesforce installed, please install it by visiting our AppExchange listing.
How does it compare to other similar products?
  • You don't need special names for merge fields. This is unlike many other products. When creating a template, you can make up any field names you want, and the merge tool discovers and matches those names with your data fields on-the-fly.
  • You can mix-and-match templates used with reports. Since merge field names are not linked to (i.e., don't have to be the same as) either data field names or report field names, you can use the same report with multiple templates. For example, you can create an Apsona report of your top opportunities from last month, filter it once for the gold partners and send using the "gold" template, and then filter it for the "bronze" partners to send using the bronze template. The two templates do not have to use the same field names.
  • It can use any of your existing document and email templates — no need to rewrite any of them, even if you have prepared them for another vendor's (such as Conga or Drawloop) products.
  • It works with cross-object reports. So you can (for example) create a report including contact fields and total value of opportunities/donations, and send the results via email.
What are its limitations?
  • The merge tool handles Word .docx format and can produce pdf files. The Excel generator requires .xlsx format. The older .doc and .xls formats are not supported, but you can use the Microsoft's Office Compatibilty Pack to circumvent this limitation.
Tell me more about creating templates.
Please watch the video at the top of this page, or visit our help and support section.