Massbrev

Skapar ett massbrev.

Innan du börjar

You are able to merge letters directly from the Associates and Campaign tables, or from layouts where one of these tables is used. The merge process is used when you want to send identical letters to several recipients.

Before you can merge letters, you must create a merge document (template) in Word in which the information from Visma Business will be inserted. The merge document contains place holders, which will be replaced with text from Visma Business. You can use the vbusmerg.HTM or norflette.HTM templates as a basis for the merge document.

Den här uppgiften

Header/Footer

You can use the DDE fields from Visma Business in headers and footers in Word.

Date fields

The macro $DocDate is in the form YYYYMMDD. The $DocDate macro is retrieved from the database, and you cannot change this. You can, however, use loose date fields, that enable you to define the sequence yourself:
  • §DocDay
  • §DocMonth
  • §DocYear

Overview templates

The templates listed below give you an overview of all of the fields that can be retrieved with macros for each table:
  • VismaTagsActor.dot
  • VismaTagsOrder.dot
  • VismaTagsProduct.dot
  • VismaTagsOrgUnit.dot
  • VismaTagsAppointment.dot
  • VismaTaggsRessurce.dot
When you start the merge process, the information from Visma Business is saved in a separate data source file. The information in the data source is then merged into the merge document you have created.
  1. Go to the Aktör or Campaign table or the layout you want to perform the merge from.
  2. Select recipients for the merged letter.
  3. Choose Massbrev processing. The Merge letter dialog box is displayed. Complete the relevant fields. See the description of this dialog box below.
  4. Answer any questions which appear on the screen during the merge process.
  5. The letters are written to a file, printed on a printer, sent as a fax or sent as e-mail. The method used depends on what you have specified in the Merge letter dialog box, what is defined in the Företagsuppgifter table and how the recipients are entered in the Aktör table.

Arbetsordning

  1. Placera markören på raden eller raderna i tabellen aktör som du vill behandla.
  2. I kategorin Hem, i gruppen Behandling, klicka på knappen Massbrev.
  3. Ange olika parametrar i parameterdialogrutan Massbrev .
    Alternativ Beskrivning
    Program Select the text editor to use when merging letters.
    Merge document Select the template for the merged letter.
    Data source Enter the path and file name for the source data, i.e. the information to be merged into the letter. Visma Business automatically suggests a file. You can override the file name.
    New file Select this check box if you want new content in the source data file to be created, based on the selection of recipients you have made. If you do not select the check box, the existing file content will be used. By default the option is selected.
    File only Select if you only want to create the source data file, based on the selection of recipients you have made. No letters will be merged.
    Printer Select if you want all merged letters to be printed. This option is selected as standard.
    Fax Select if you want the recipients that are entered with a fax number in the Aktör table to receive the merged letter by fax.
    Anm: The Skriv om inte fax vid massbrev option in the Företagsuppgifter table must be selected. You must also have a fax program installed that can read the fax number that Visma Business sets in the document.
    E-mail Select if you want the recipients entered with an e-mail address in the Aktör table to receive the merged letter as an e-mail. Enter a subject for the e-mail in the field to the right. Recipients that do not have an e-mail address will receive the letter by fax if they have a fax number. Otherwise, the letter will be printed out.
    Anm:
    • An e-mail program must be installed that is integrated with a fax system.
    • The Fax om inte mail vid massbrev option in the Företagsuppgifter table must be selected.
    • The Skriv om inte fax vid massbrev option in the Företagsuppgifter table must be selected.
    File Select if you want to save the merged letters in a file instead of printing or mailing them. In the field to the right you enter the path and file name of the file.
    Document description Enter a description for the merged letter here. This will appear later in the Description field in the document overview (Document links table).
    Our ref. Your initials appear here in lower case. They are inserted in the letter automatically during the merge if the template is created to do this.
    User Your name appears here. It is automatically inserted in the letter during the merge if the template is created to do this.
    Title This contains your title. This is on the condition that the title has been entered in the Aktör table.
    Att. The person for whom the letter is intended at the recipient, for example the Sales Manager or General Manager. The text is automatically inserted in the letter during the merge if the template is created to do this.
    Password If you want to protect the merged letter with a password, you enter the password in this field. The letter can then only be opened if you know the password.
    Private The Private option must be selected when you enter a password.
    Date The current date appears here. It is automatically inserted in the letter during the merge if the template is created to do this. You can change the date if you wish.
    Group Select the group to which you want the merged letter to belong. The chosen document group is saved in the Document table.
    Anm: You create document groups in the Text table.

Resultat

A data source file is generated every time you merge a document. The file is stored in the My documents directory. If this directory does not exist, the data source file is stored under Visma directory\Documents. You must have privileges to set up folders, if not the administrator will has to set the folder up manually. A data source file is set up for each day. If you do not choose to delete the file, a data source file will be stored for each day, with the file name MrgActorYYYYMMDD.txt. The content will be overridden every time a file is run. The data source file contains the following merge fields from the Associates table:
  • ACTOR_NO
  • NAME
  • ADDRESS_1
  • ADDRESS_2
  • ADDRESS_3
  • ADDRESS_4
  • POST_NO
  • POST_PLACE
  • COUNTRY
  • LANGUAGE
  • MAIL_ADDRESS
  • PHONE
  • PRIVATE_PHONE
  • MOBILE_PHONE
  • PERSONAL_SEARCHER
  • FAX
  • CUSTOMER_NO
  • SUPPLIER_NO
  • SELLER
  • BUYER
  • RESPONSIBLE
  • BUSINESS_NO
  • FREE_INFO_1
  • FREE_INFO_2
  • FREE_INFO_3
  • FREE_INFO_4
  • FREE_INFO_5
  • FREE_INFO_6
  • ATTENTION


Vi uppskattar din feedback. Skicka feedback om detta ämne till Visma.