Publisher 2003 merge with Access DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FrankSpokane - 20 Mar 2005 03:47 GMT

I recently wrote an Access 2003 database for a client, and discovered they
they are using Publisher to create coupons they sell based on fields in the
database I wrote. This would include a graphic for the company's logo, then
their standard address info, and then a few fields with descriptions of the
product the are offering for these Coupons which are sold in a booklet.
They are doing this all manually now, regardless of this info now being in
their database. Is there a way to merge access data with publisher? I see you
can do a simple mail merge.

Reply to this Message

Ed Bennett - 20 Mar 2005 12:16 GMT

> They are doing this all manually now, regardless of this info now
> being in their database. Is there a way to merge access data with
> publisher? I see you can do a simple mail merge.

Yes, the Mail and Catalog Merge wizard in Publisher allows merging of data
from Microsoft Access databases (in fact, the standard Publisher address
list IS an MDB)

If the data are returned as a result of a query, you may have trouble, but
otohoerwise it should be plain sailing.

The Catalog Merge is the one to use if you want to merge a different logo
for each coupon.

Signature

Ed Bennett - MVP Microsoft Publisher

Reply to this Message

Mary Sauer - 20 Mar 2005 12:17 GMT

Access databases are compatible with Publisher. Look into the catalog merge.

Lots of help here
http://office.microsoft.com/en-us/assistance/CH062524751033.aspx

Signature

Mary Sauer MS MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

>I recently wrote an Access 2003 database for a client, and discovered they
> they are using Publisher to create coupons they sell based on fields in the
[quoted text clipped - 4 lines]
> their database. Is there a way to merge access data with publisher? I see you
> can do a simple mail merge.

Reply to this Message

Rate this thread: