Microsoft Office Forums Populate cells of a table with data from a MySQL database

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-18-2019, 09:50 AM
fufabi fufabi is offline Populate cells of a table with data from a MySQL database Windows 10 Populate cells of a table with data from a MySQL database Office 2016
Novice
Populate cells of a table with data from a MySQL database
 
Join Date: Apr 2019
Posts: 1
fufabi is on a distinguished road
Default Populate cells of a table with data from a MySQL database


Hi all,


At work I received the task to create a word template that once opened fill automatically some fields in a table with data from a MySQL database and then the file is saved in a folder that changes according to some of those fields.


I solved the part for saving the file with a macro, but I have no idea how I can do the first part. Is it possible? Can someone give me an input please?
Reply With Quote
  #2  
Old 04-18-2019, 10:19 AM
Charles Kenyon Charles Kenyon is offline Populate cells of a table with data from a MySQL database Windows 10 Populate cells of a table with data from a MySQL database Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 6,191
Charles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to all
Default

The general method is called Mail Merge.
MailMerge Resource Center
Reply With Quote
  #3  
Old 04-18-2019, 08:25 PM
macropod's Avatar
macropod macropod is offline Populate cells of a table with data from a MySQL database Windows 7 64bit Populate cells of a table with data from a MySQL database Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,673
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Depending on what you're doing, the task might be accomplished using a DATABASE field. See, for example: https://www.msofficeforums.com/mail-...html#post67097
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 bobznkazoo Excel 2 03-27-2014 11:14 AM
Populate dropdown list with data from Access table spw4000 Office 0 02-24-2012 05:22 AM
Populate cells of a table with data from a MySQL database How do I dynamically update data in a Word Document from a database table RSchmidt Word 1 07-14-2011 04:27 PM
Using data entered in prompt to search database table BluRay Word 1 03-25-2011 01:47 AM
Populate cells in Word from a database hotlilshan Word 3 12-09-2008 01:51 PM


All times are GMT -7. The time now is 07:30 AM.


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