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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies