Exponenciel - Efficient and affordable Sage ACT! add-ons

You are here: home > support > online help > excel quote-invoice maker for act! 2010 > table of content

Online help
Excel Quote-Invoice Maker

Creating a merged document

Using the Autonumbering feature

Naming your merged documents

Excel Quote-Invoice Maker for ACT!, also helps you automatically name your documents, which is particularly useful if you want to include the name of the company, of the contact or any information contained in a contact or opportunity field.

You may want to take a look at our AutoNumbers add-on which automatically numbers your opportunities at creation time (or later). The number is stored in one of the opportunity field and therefore may be included in the name of your merged document.

To define the naming convention, go to Options>Preferences.

By default, the naming convention consists of your template name, but you can make it whatever you want by clicking the Edit... button and editing the syntax.

In the example above, if your template name is Quote.XCT, the company of the contact Best Entertainment and the record manager of the opportunity Chris Huffman, your document will be automatically numbered Quote-Best Entertainment-CH.

For more on how to use the Syntax Editor, see Using the AutoNumber syntax (opens in a new window). It is a topic of our AutoNumbers addon but it uses a similar Syntax Editor. The topic lists all the functions and variables available.


  • The Autonumbering feature is particularly important when running in automated mode, as you won't get an opportunity to manually name the files before they are saved.
  • File names are automatically incremented (as in Document1.XLS, Document2.XLS, etc.) so that you never risk to overwrite an existing file.
  • If you include more than one opportunity in your merged document and your naming convention includes opportunity fields, the first opportunity of the merged document will be used to provide values for the naming convention.

Creating a merged document

Using the Autonumbering feature

Back to the Table of Content


Across this Web site, ACT! and ACT! Premium, Sage ACT! Pro and Sage ACT! Premium are referred to as ACT! or Sage ACT!.

home | products | support | order now | web design | resellers | contact us | meet now
Design by Exponenciel

Exponenciel has been a leading developer of Sage ACT! add-ons, Sage ACT! addons, Sage ACT! plug-ins, Sage ACT! plugins since 2001.
ACT!, ACT! for Workgroup, ACT! for Web, Sage ACT! Pro and Sage ACT! Premium are registered trademarks of Sage Corporation.