Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-389523%22%20slang%3D%22en-US%22%3EI%20also%20have%20a%20mail%20merge%20question%20but%20this%20has%20to%20do%20with%20connecting%20to%20SQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389523%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20distribute%20a%20word%20document%20that%20would%20auto-populate%20labels.%3C%2FP%3E%3CP%3EI%20would%20like%20to%20embed%20the%20connection%20string%20in%20the%20document%20and%20not%20rely%20on%20an%20external%20ODBC%20connection.%26nbsp%3B%20When%20the%20word%20document%20is%20opened%2C%20it%20queries%20a%20a%20SQL%20view%20and%20merges%20the%20data%20into%20a%20finished%20merged%20Avery%20label%20pages.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
GADOI
Occasional Visitor

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

1 Reply

@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.