
Create document templates

- Date
- Clerk
- Document name (Freely assignable name for the document template)
- Print layout (print layout on which the document template is to be based)
After clicking on the button [New template] the new document template is created and all data maintained in the popover dialog is automatically entered in the corresponding fields.
In the subject and body text of the document template, you can integrate any number of placeholders at any position, which are automatically replaced with the corresponding value when the document is created. The placeholders {subject} and {document} are used to include the subject or body text in an HTML template. All placeholders with the prefix {e-...} refer to the recipient's data, e.g. letter salutation, company name, address, city, etc. All placeholders with the prefix {s-...} refer to data of the sender, i.e. your company, such as company name, address, bank details, etc.
Automatic actions

An automatic action is only created when a document is created for a contact. If a form letter is created whose template contains an automatic action, this action is created in all contact data records that were selected for the creation of the form letter.
Select contacts for correspondence of all kinds
The procedure for contacting customers, suppliers or other contacts by letter, fax, form letter, e-mail or newsletter is always identical in gFM-Business. If only one data record is to be contacted, this must first be entered in the CRM-module [Customers] can be called up. This is done by a simple search, for example using the customer number or company name. If a mail merge document is to be sent to several contacts, all the desired data records must be entered in the CRM module [Customers] can be called up. This is done by entering any search criteria such as a zip code range, customer types or any free selection fields. gFM-Business allows the selection of data records across all data fields in all modules.
To create one or more data records in the CRM module [Customers] click in the toolbar on the icon [Search]The search mode is then called up - recognizable by the small magnifying glass symbol in each input field. You now have the option of selecting the desired customers according to any criteria. To enter a zip code area, you would enter the following in the [Postal code] for example
26000...26999
to restrict the search results to the zip code area "26". You can find out which other criteria can be used in gFM-Business and other FileMaker-based database solutions in the article "Search and find in gFM Business". To start the search, click in the Function bar at the bottom on the button [Search] or press the [Enter]-button. gFM-Business then calls up all data records that match the search criteria entered.
Create and send letters, faxes and form letters
To create and send a letter or fax for a selected contact data record, the CRM module [Customers] in all masks the functions [New letter], [New fax] and [New serial document] are available. To create a new document, select the corresponding function in the function menu or via a Favorites button in the toolbar. A popover dialog then opens in which you can enter the following data for the new document:
- Date
- Customer ID (automatically contains the customer ID of the data record called up, field is omitted when creating a serial document)
- Clerk (person responsible to whom the document is assigned)
- Document name (Free name of the document)
- Template (document template on which the new document is to be based)
- Print layout (print layout on which the new document is to be based)
After entering the above data, the new document is created by clicking on the [New document] and gFM-Business then switches directly to the new document in the [Correspondence]. The field [Customer ID] is omitted in the popover dialog for mail merge documents because this function creates the specified document for each data record called up.
When the new document is created, all placeholders from the document template are automatically replaced by the corresponding fields of the assigned contact data record. If there is an automatic action in the document template, a new action is automatically created when the new document is created and assigned to the corresponding contact data record.
Print letters and serial letters
To output a letter, fax or form letter to a printer, click on the [Print]and a popover dialog will open for the selection of all print options:
- Print layout (print layout on which the document is to be printed)
- Data records (Selection of whether the current data record or all called data records (mail merge) should be printed)
- Copies (number of copies to be printed)
- Printer (Printer on which the document is to be output)
- Sort (sorts called data records for mail merge according to certain criteria)
- Sort sequence (Sort criterion in ascending or descending order)
- e-mail (e-mail address of the recipient for sending e-mails)
- Send by e-mail (sends the document by e-mail in addition to printing)
- Send without printout (sends the document by e-mail only)
After clicking on the button [Print] the document or documents are output to the printer. If automatic document archiving has been activated, the document is archived as a PDF file at the same time.
Create and send emails and newsletters

There are differences to other documents for emails and newsletters, particularly with regard to technical details such as document format (text or HTML), sending via client or directly via SMTP and the desired sending address. This information can already be specified in the document template so that the settings are automatically made in the documents created when an e-mail or newsletter is created.
Document template for e-mails and newsletters

Under the tab [Template] all information about the document template itself is maintained, such as the subject, letter text, fields for reference numbers or an automatic action with optional resubmission. These fields are also available for document templates for letters, faxes or serial letters.
Under the tab [E-Mail] all details required for sending e-mails and newsletters are maintained, such as the sending address, sending type and document format. The register [E-Mail] contains three further subordinate registers [Text view], [HTML template] and [Preview]. Under the tab [Text view] the letter text can be edited and formatted in the same way as in the main view. In the tab [HTML template] you can enter any HTML template on which the email or newsletter to be sent is to be based. In our example, we have used a very simple HTML template, which can of course also have a more complex structure and can also contain images and buttons, for example.
Example HTML template
<div>
{subject}
</div>
<div>
{document}
</div>
In this sample HTML template, there are simply two paragraphs, each with a <div>-tag and contain the subject and body text of the document. The HTML template can of course contain other elements, for example to include graphics or buttons. You can see what the email and HTML template will look like when it is received by the recipient under the [Preview] be considered.
Sending e-mails with file attachments
Under the tab [File attachments] any number of files can be attached to the document template. When sending an e-mail via an SMTPServer all attached files are sent with the e-mail. The register [File attachments] is also in the document under [Correspondence > Documents] available.
Please note that for technical reasons, only the first file attachment can be sent with the e-mail when sending via the local e-mail client. Sending multiple file attachments is only possible when sending directly via an SMTP server. SMTP sending addresses can be found under [Settings > Preferences > Devices] can be set up and managed.
Scan and archive documents

To scan and archive a contact-related document, the CRM module [Customers] The "Scan document" function is available in every screen. After selecting this function, a popover dialog opens for entering the following data for the new document.
- Document name (freely assignable document name)
- Document type (Types can be defined under Settings > Preferences > Value lists)
- Reference date (date of the document)
- Reference no. (Reference number of the document, e.g. document number)
- Remarks (free comments on the document)
- Automatic action (optional)
- Action date
- Type of action
- Reason for action
- Contact person
- Action text
- Resubmission date
- Appointment date
In addition to the document data, an optional action can be entered, with a resubmission date and deadline if desired. After confirming with the [Archive] the scan dialog of your scanner opens and you can scan the document immediately. Once the scanning process is complete, you can either scan another page or end the scanning process and save the document in gFM Business.
Documents saved in a contact are managed under [Customers > Events > Archive]. A full-text search is also available there, which can be used to search in all documents assigned to the current data record.
gFM-Business also supports the scanning of business cards under [Customers > Contacts > Contact persons] and the scanning of receipts in the Cash book of the module [Invoicing].
Part 3: Products, suppliers and item stock
This was the second part of the series "Using gFM Business effectively". In the first part This series dealt with the management of customers and addresses and the optimal use of the CRM module [Customers]. In the next part, we will explain how you can use gFM-Business to manage articles with categories, attributes, suppliers and article stock and how articles can be easily posted to any documents.
Buy gFM-Business in the online store
Maintenance: gFM-Business 1.8 and higher includes free upgrade to gFM-Business 2.0.
Benefit now from the low prices of the previous version!
- gFM-Business Light full version
- gFM-Business Light Upgrade from gFM-Business free
- gFM-Business Professional single user version
- gFM-Business Professional multi-user version
All articles in the series
- Use gFM Business effectively and save time. Part 1: CRM
- Use gFM Business effectively and save time. Part 2: Documents and correspondence
- Use gFM Business effectively and save time. Part 3: Article management
- Use gFM Business effectively and save time. Part 4: Invoicing and documents

Markus Schall has been developing individual databases, interfaces and business applications based on Claris FileMaker since 1994. He is a Claris partner, FMM Award winner 2011 and developer of the ERP software gFM-Business. He is also a book author and founder of the M. Schall Publishers.






