Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word

LinkBack Thread Tools Display Modes
Old 03-17-2017, 01:50 PM
Hoser Hoser is offline Windows 7 64bit Office 2010 64bit
Join Date: Mar 2017
Posts: 1
Hoser is on a distinguished road
Default Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data?


I'm trying to figure out the best way to merge a TON of data into a custom template in word. The templates are 30-100 pages in length, and certain fields in the word template could have 1-2 pages of information inserted - so need to ensure the data fields can hold a large amount of information. There will likely be more than 100 fields to be filled in in the template as well.

The data would have to come primarily from 2 sources - MySQL (for data that is scraped automatically from numerous data sources on the web to be inserted into both Excel & Word) and excel (which would likely be used in tables, to produce charts, etc - and that would be inserted into Word).

I'm not sure where to begin? It seems like this might be too heavy duty for mail merge? Should I consider incorporating Access 2010 to house the data? I prefer MySQL just because I've used it in the past for web scraping.

Thanks for any help!!
Reply With Quote
Old 03-17-2017, 03:47 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,355
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

Mailmerge is certainly a possibility, as it can handle memo data fields. A mailmerge, however, can only handle one data source at a time. Even that could be worked around using one or more DATABASE fields in the mailmerge main document to extract data from the secondary source.
Paul Edstein
[MS MVP - Word]
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Check boxes that insert data from Excel spc94 Word VBA 1 06-22-2015 01:46 PM
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data Faldinio Word VBA 7 10-19-2014 06:03 AM
Word 2010 Field widths from linked Excel data. DPB Word 1 06-25-2014 09:31 PM
saving data in excel 2010 from excel 2003 johnkcalg Excel 1 02-06-2012 07:33 PM
word insert data into excel elemental Word 1 04-29-2011 06:33 PM

All times are GMT -7. The time now is 09:56 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft