#1
|
|||
|
|||
Connecting data from SQL server
Hello, Is there a way in msword, to populate data from sql server to my combobox using vba OR mailmerge? |
#2
|
|||
|
|||
It's been a long time since I've done this so it's going to be vague, and for that I apologize.
1. Install an ODBC (Online Database Connection) driver. 2. Use the ODBC driver to create an ODBC link to the SQL database. 3. Access the link using MS Access; create a query to pull the needed info for the merge. 4. In Word you then use the Access query as the data source for the merge. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Connecting OneNote and Outlook tasks for multiple users over Exchange Server | smq | OneNote | 1 | 08-14-2017 03:40 PM |
Why do you need to enter your password twice when connecting to an SQL Server database? | Dedication99 | Mail Merge | 0 | 08-05-2016 02:18 AM |
Import excel data in to SQL Server | DavidBrown | Excel | 0 | 08-08-2011 04:49 AM |
Connecting outlook to a outlook web server. | isesoteric | Outlook | 3 | 01-19-2007 09:21 AM |
Questions about connecting a Mac to Exchange Server 2003 | imported_bankboysb | Outlook | 0 | 09-18-2006 02:11 PM |