Forum Discussion

GADOI's avatar
GADOI
Copper Contributor
Mar 27, 2019

I also have a mail merge question but this has to do with connecting to SQL

I would like to distribute a word document that would auto-populate labels.

I would like to embed the connection string in the document and not rely on an external ODBC connection.  When the word document is opened, it queries a a SQL view and merges the data into a finished merged Avery label pages.

 

Any suggestions?

 

Thanks

  • tweetiepie1983's avatar
    tweetiepie1983
    Brass Contributor
    Jul 24, 2019

    GADOIYou can populate the labels in word by using the below method..

     

    Not sure how this will work with SQL though..

     

    Create and print a page of identical labels

    1. Go to Mailings > Labels.

    2. Select Options and choose a label vendor and product to use. Select OK.

      If you don’t see your product number, select New Label and configure a custom label.

    3. Type an address or other information in the Address box (text only).

      To use an address from your contacts list select Insert Address Picture of Insert Address button .

    4. To change the formatting, select the text, right-click, and make changes with Font or Paragraph.

    5. Select OK.

    6. Select Full page of the same label.

    7. Select Print, or New Document to edit, save and print later.

Resources