Fill Word docs from Access DB tables

[SM]

When it comes to VBA or any type of programming, I know practically nothing.
Not to mention, I don't know much about Access, however I'm hoping that this
is within' my reach.

What I'm trying to do is populate 4 or 5 different Word documents with data
found inside an Access DB. These 4 or 5 Word docs are all from different
organizations, however a lot of the information requested is the same such as
Business Name, date, client name etc., so I was hoping to make a single form
in Access that would then basically populate certain fields within' these
Word documents.

I'm pretty sure this is possible, but after searching through countless
articles I still haven't found a foolproof and direct way to do this. I
understand that DDE is a bit outdated and that most people use Automation to
perform these types of tasks, but I'm just completely lost when it comes to
either of them.

Thanks for any help you can give!

 

[Fred]

One way to pull it from the Word end would be to use Word mail merge. Set
the Access Table / Query up as the mail merge data source, and then just
insert the field codes wherever you want the data.

 

[Roger Carlson]

--
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "AutomatingWordFromAccess.mdb" which illustrates how to do
this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[pietlinden]

When it comes to VBA or any type of programming, I know practically nothing.  
Not to mention, I don't know much about Access, however I'm hoping that this
is within' my reach.

What I'm trying to do is populate 4 or 5 different Word documents with data
found inside an Access DB.  These 4 or 5 Word docs are all from different
organizations, however a lot of the information requested is the same such as
Business Name, date, client name etc., so I was hoping to make a single form
in Access that would then basically populate certain fields within' these
Word documents.

I'm pretty sure this is possible, but after searching through countless
articles I still haven't found a foolproof and direct way to do this.  I
understand that DDE is a bit outdated and that most people use Automationto
perform these types of tasks, but I'm just completely lost when it comes to
either of them.

Thanks for any help you can give!

Download Albert Kallal's "Super Easy Word Merge" code. It should do
what you want.
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[SM]

Thanks everyone. I was able to find out how to make Mailmerge work and I'm
up and running.

Have a good day!

 

[pietlinden]

Check out Albert Kallal's "Super Easy Word Merge" here:
http://www.members.shaw.ca/AlbertKallal/msaccess/WordMerge20.zip

Really easy to use - Albert did all the hard work for you.

 

[a a r o n . k e m p f]

so you can

a) be non-techie for the rest of your life (practically beg those
indians to take all the software development money from your own
company)
b) grow some cojones and learn SQL Server

you don't need WORD and you don't need MAIL MERGE.
What you need is a decent enterprise level reporting engine.

-Aaron