A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Merge fields in Word updated automatically?



 
 
Thread Tools Display Modes
  #1  
Old May 19th, 2004, 04:34 PM
Joe
external usenet poster
 
Posts: n/a
Default Merge fields in Word updated automatically?

Hello,

I am running Word 2000 along with Access 2000 (with
Windows 98se). I have a simple address database in Access
(FirstName, LastName, Street, Zip, etc.) and want to
create tables in Word by merging (or "insert database").
I can do such, but I cannot figure out how to get the
table to update automatically when I change something in
the Access file.

I want to have several printable formats of this
infomation from Access. The people's names and numbers
are constantly changing, and I do not want to have to
recreate each Word document everytime someone's info is
updated.

How can I get a merged table to be updated automatically
when a field in Access changes or is updated?

Thanks and make it a great day!

Joe
  #2  
Old May 20th, 2004, 04:17 PM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default Merge fields in Word updated automatically?

Hi Joe,

You can't get a merged table to update - there's no dynamic
link in a merge result. But you should be able to manage
something using "Insert database".

When you do this, in the very last dialog box, there's an
inncuous appearing checkbox. Activate this, and you should
have a link back to the database table.

To force the update, click on the table and press F9.

I am running Word 2000 along with Access 2000 (with
Windows 98se). I have a simple address database in Access
(FirstName, LastName, Street, Zip, etc.) and want to
create tables in Word by merging (or "insert database").
I can do such, but I cannot figure out how to get the
table to update automatically when I change something in
the Access file.

I want to have several printable formats of this
infomation from Access. The people's names and numbers
are constantly changing, and I do not want to have to
recreate each Word document everytime someone's info is
updated.

How can I get a merged table to be updated automatically
when a field in Access changes or is updated?


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

  #3  
Old May 20th, 2004, 04:21 PM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default Merge fields in Word updated automatically?

If you use the merge approach, you do have to recreate the output document
each time you change your Access data. but you could consider writing an
Access macro or VBA function to do that so you didn't have to open each Word
document manually and re-merge it.

If you are just using Insert database, make sure you choose the optin to
insert the database as a field (it will be a { DATABASE } field). Then, all
you should need to do is open each document, select its contents, and press
F9 to get the up-to-date data before printing. If necessary you could do the
same as above (e.g. write an Access macro/function to do this automatically)
or you could put an AutoOpen macro in each Word document to select all the
field and execute them.

--
Peter Jamieson

"Joe" wrote in message
...
Hello,

I am running Word 2000 along with Access 2000 (with
Windows 98se). I have a simple address database in Access
(FirstName, LastName, Street, Zip, etc.) and want to
create tables in Word by merging (or "insert database").
I can do such, but I cannot figure out how to get the
table to update automatically when I change something in
the Access file.

I want to have several printable formats of this
infomation from Access. The people's names and numbers
are constantly changing, and I do not want to have to
recreate each Word document everytime someone's info is
updated.

How can I get a merged table to be updated automatically
when a field in Access changes or is updated?

Thanks and make it a great day!

Joe



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.