Mail Merge with Access

[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.
Hoping someone can help me with this peoblem
Pauline

 

[Doug Robbins - Word MVP]

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.

--
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

 

[Pauline]

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

 

[Cindy M -WordMVP-]

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