Skip links

Use gFM Business effectively and save time. Part 2: Correspondence and document archive

Save time with gFM-Business ERP software

Use gFM-Business effectively: Correspondence and document managementIn the second part of the series "Using gFM-Business effectively and saving time", you will learn how to use the software to write to customers, send emails and newsletters and how to read and manage paper documents in gFM-Business using a scanner. We explain how you can address a form letter to a specific customer group and send a graphic newsletter based on an HTML template. Send e-mails with any number of file attachments via any number of (SMTP) mail servers. The template-based correspondence module, in combination with the individually customizable and expandable print layouts with FileMaker Pro, opens up many possibilities for staying in regular contact with all desired customers.

Create document templates

Create document templatesIn the module [Correspondence] can be used to manage any number of document templates on which letters, faxes, e-mails or newsletters can be based. A document template essentially contains the same input fields as a document, but the recipient details are missing. To create a new document template, switch to the [Correspondence > Templates] and click on the icon in the toolbar [New]. This opens a popover dialog for entering the following data for the new document template:

  • Date
  • Clerk
  • Document name (Freely assignable name for the document template)
  • Print layout (print layout on which the document template is to be based)

Correspondence: New template

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

Automatic action with optional resubmissionOptionally, an action can be entered in the document template that is automatically generated in the corresponding contact data record when a document is created. In this way, for example, follow-ups can be created automatically to follow up the contact by telephone when a document is created for a contact. The action can then be found in the action history of the respective contact data record, and any resubmission is entered in the clerk's resubmission list and, if necessary, in the calendar.

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

Select contacts for correspondenceThe 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.

Customers: Search and select data records

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

Correspondence: letters, e-mails, faxes, newsletters, form lettersTo 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)

Customers: New document

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)

Correspondence: Print document

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

Create and send emails and newslettersIn principle, an e-mail or newsletter is created in the same way as a letter or mail merge. In the CRM module, select [Customers] first select the desired contact or all desired contacts and then select the function [New E-Mail] resp. [New serial document]which are displayed in every mask of the CRM module [Customers] is available. After entering the data for the new document in the popover dialog and confirming, the new document(s) is/are created in the [Correspondence] generated.

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

Create document templatesIn principle, a document template for emails and newsletters contains the same fields as any other document template. The subject corresponds to the subject field of the e-mail, the letter text corresponds to the text of the e-mail. The mask under [Correspondence > Templates] has the three register buttons [Template], [E-Mail] and [File attachments].

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.

Correspondence: e-mail with HTML template

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

Add and send file attachmentsUnder 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

Scan and archive documentsWith gFM-Business Light and Professional, paper documents can also be scanned and archived with TWAIN-compatible scanners. To be able to use this function, at least one scanner must first be installed under [Settings > Preferences > Devices] gFM-Business supports the use of any number of TWAIN-compatible scanners (32-bit drivers). With the button [Update] in the area "TWAIN scanner" gFM-Business automatically searches for all scanners installed in the system and displays them in a list. If several scanners are found, you can define a scanner as the default with the function "Use this scanner".

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.

Scan paper documents

  • 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!

All articles in the series

Leave a comment

Share this page:

ERP software as flexible as your company.
We will be happy to advise you.

Customizable ERP software for Mac, Windows and iOS.

You are here: Save time with gFM-Business Part 2: Correspondence and archive