Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-07-2014, 02:43 PM
TDW1984 TDW1984 is offline Macros and External Sources Windows 8 Macros and External Sources Office 2007
Novice
Macros and External Sources
 
Join Date: Dec 2014
Location: UK
Posts: 1
TDW1984 is on a distinguished road
Default Macros and External Sources

Hi there,

My job requires me to write a lot of reports in word. A lot of the information used to write these reports (names, date of birth, etc) are held in an online data base. I was wondering if a macro(s) could be used to extract details from the database in to word or if there is a more appropriate tool in word to do this.



Any ideas or tips would be much appreciated.

Last edited by TDW1984; 12-07-2014 at 03:58 PM.
Reply With Quote
  #2  
Old 12-08-2014, 03:21 AM
gmayor's Avatar
gmayor gmayor is offline Macros and External Sources Windows 7 64bit Macros and External Sources Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,104
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

What sort of 'on line database' and how many records are there to access? Word can get data from a variety of sources, but to know how to approach it, it helps to know what the starting point is.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 12-08-2014, 05:52 AM
Charles Kenyon Charles Kenyon is offline Macros and External Sources Windows 7 64bit Macros and External Sources Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,138
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

You might want to look at Mail Merge which is Word's simplest tool for inserting data into a document.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Data gathering from varied sources for different outcome letters cs225 Word 2 10-19-2014 06:23 AM
Macros and External Sources Using macros to highlight worksheet words referenced in external list/doc. Daniel_NYC Word VBA 1 04-21-2014 03:35 PM
Macros and External Sources Combining word documents with sources yoel Word 3 07-21-2011 10:45 PM
When Printing a file Sources/Details included BigTunz Word 0 03-01-2010 01:24 AM
Help w/ external data bellest Excel 0 11-11-2005 12:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:33 AM.


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