Merging from two sources (Word and Access) and updating both

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shimon - 27 May 2008 20:57 GMT

Hello Everybody,
I have a database where we keep information about or products, which include
Title, minimum price, estimated price etc.
We have a seperate person working on the descriptions of the item, which are
periodically changed and updated.
Each item has a unique Atonumber ID.
I would like to have a word document that has the UID and text, and have the
final document pull theTitle and price info from the DB and the description
from the word document.
Each document has a number of items, but they are not nubered sequentially
(by the autonumber) eventually, we put it into a catalog and assign each
item a lot number.

I will add the relevant files if that is necessary. Right now the files ae
bi-lingual, but i can clean it up.

Thans alot if for any help,
Shimon

Reply to this Message

Doug Robbins - Word MVP - 27 May 2008 23:00 GMT

Mail merge can only use a single, flat file as the data source.

To do what you want, you would have to use a macro that amounted to a
"roll-your-own" equivalent to Mail Merge with some added functionality.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hello Everybody,
> I have a database where we keep information about or products, which
[quoted text clipped - 14 lines]
> Thans alot if for any help,
> Shimon

Reply to this Message