Mail Merge with Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pauline - 13 Jun 2004 01:15 GMT

I have a mail merge with an Access query that I have been
using for some time and have added another field to the
query (e-mail) but it won't recognise it in the word merge.
I am using DDE. Actually this is happening to two queries
and mail merges (using different tables).
I am using Office XP.
Hoping someone can help me with this peoblem
Pauline

Reply to this Message

Doug Robbins - Word MVP - 13 Jun 2004 01:55 GMT

Have you tried re-attaching the data source? Or, turn on the display of
the mailmerge toolbar via View>Toolbars and click on the third button from
the left to view the mailmerge recipients and then click on the Refresh
button in that dialog and see if that refreshes the connection ot the query
and causes the field to be displayed.

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

> I have a mail merge with an Access query that I have been
> using for some time and have added another field to the
[quoted text clipped - 4 lines]
> Hoping someone can help me with this peoblem
> Pauline

Reply to this Message

Pauline - 13 Jun 2004 02:18 GMT

Yes I have tried both of those and it still won't bring in
the new fields

>-----Original Message-----
>Have you tried re-attaching the data source? Or, turn on the display of
[quoted text clipped - 13 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 13 Jun 2004 12:07 GMT

Hi Pauline,

> I have a mail merge with an Access query that I have been
> using for some time and have added another field to the
> query (e-mail) but it won't recognise it in the word merge.
> I am using DDE. Actually this is happening to two queries
> and mail merges (using different tables).
> I am using Office XP.

If you link to the query using a new document, do the new
fields show up in the list of field names?

If not, could you open the query in SQL view, copy the SQL
statement and paste into your reply, please?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
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 :-)

Reply to this Message