How do I create mailing labels, form letters or envelopes from my QuickBase application with Microsoft Word?

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

1. Create a new report that includes all of the fields that you want to include in your mailing labels, form letter or envelopes. Expand the "COLUMNS TO DISPLAY" section and turn on only the columns that you need for your mail merge. Turn off all unnecessary columns.

For more information about creating a view, see https://www.quickbase.com/help/creating_a_new_view_from_scratch.html.

2. On the Report builder page, click on "Custom options" to expand the "ADDITIONAL OPTIONS" section. In the "Format:" drop down list select "Comma-Separated Values", and then click "Display". You are prompted to save the file to disk.

Alternatively if you already have a view that displays the rows and columns you want in the browser window, then go to that view and click on the "I want to..." button. Choose "Export this view to a spreadsheet". You are prompted to save the file to disk.

3. Give the file a name with a .CSV extension, and be sure to remember which folder you saved it in.

4. Now you're ready to do your Mail Merge in MS Word. When MS Word prompts you for a Data Source or list just select the file that you saved from QuickBase in step 3 above.

Tags:

39606 reads

Comments

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * Type the characters you see in this picture.

(verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Knowledge Base