Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Creating Letters that import info from databases

Featured Replies

  • Newbies

I would like to create a database that takes information like name, test scores, recommendations and inserts these results into a generic word document or text document (or Form) so it can be personalized to each individual.

Where can I look to find out how this can be done just so I can get myself on the right track.

Thanks in advance.

What you are looking for is Merge Fields.

See the online help smile.gif

Ano is right, you need merge fields (CTRL + F9 and type mergefield) so if the field in the database is "DateEntry" then in word it would be {mergefield dateentry}.

A thing to note - if you have relational data displayed, when you export you will have to select the different tables and export those fields too. I suggest you just click on "export all" as when you merge, word will only take the fields referenced in your form file (word document). Export the data as merge type "mer"

In word you can also create paragraphs that will alter the content based on field i.e Yes/No radio buttons. e.g {If {mergefield Current} = "Yes" "put in this text here" "else put in this"}.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.