Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2021, 05:50 AM
Formd Formd is offline Connecting data from SQL server Windows 7 32bit Connecting data from SQL server Office 2007
Advanced Beginner
Connecting data from SQL server
 
Join Date: Feb 2015
Location: TX
Posts: 34
Formd is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 09-22-2021, 08:30 AM
jthomas666 jthomas666 is offline Connecting data from SQL server Windows 10 Connecting data from SQL server Office 2016
Competent Performer
 
Join Date: Jun 2016
Location: Birmingham & Warner Robins
Posts: 157
jthomas666 will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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 data from SQL server 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft