Word Mail Merge using Access database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jaime Jackson - 31 Mar 2004 00:40 GMT

2 issues:

1) can only get 1 record per page when I want a list of
however many fit on the page

2) I am getting a number in one field versus the listed
field, I know it's actually a lookup Wizard field, but I
don't want the key field I want what's shown.

Thanks for any help

Reply to this Message

Graham Mayor - 31 Mar 2004 08:10 GMT

> 2 issues:
>
> 1) can only get 1 record per page when I want a list of
> however many fit on the page

Use a catalog/directory merge

> 2) I am getting a number in one field versus the listed
> field, I know it's actually a lookup Wizard field, but I
> don't want the key field I want what's shown.

Explain this better

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<

Reply to this Message

Jaime Jackson - 31 Mar 2004 20:32 GMT

>> 2) I am getting a number in one field versus the listed
>> field, I know it's actually a lookup Wizard field, but I
>> don't want the key field I want what's shown.
>
>Explain this better

I have one field in 1 table that looks up items in another
table (i.e., in one table that has employees in it, look
up companies from another table) only gives me id not
company name.

Reply to this Message

Graham Mayor - 01 Apr 2004 13:43 GMT

>>> 2) I am getting a number in one field versus the listed
>>> field, I know it's actually a lookup Wizard field, but I
[quoted text clipped - 6 lines]
> up companies from another table) only gives me id not
> company name.

I am no expert with Access, but Word will only merge from a single table.
You will probably have to run a query on the data to get the necessary
format to merge.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<

Reply to this Message

Doug Robbins - Word MVP - 01 Apr 2004 23:37 GMT

Use a select query in Access with the two tables linked on the relevant
fields.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

Reply to this Message