Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
steve goodrich
 
Posts: n/a
Default help with mailmerge please

I've been using the mailmerge feature in microsoft word 97 for years,
merging with a query in Microsoft access 97. this has worked great for
years.
My company has just upgraded to Microsoft office 2003 standard. so I've now
got Word 2003 and Access 97. When I ask mailmerge to find the data, I
navigate to the access 97 query as before, but the results show no
recipients.
I've found a workround by copying the access 97 query into an excel
spreadsheet and using that as the data source but it's not ideal.
Why can't I use the access 97 query as the data source as before, or am I
missing something.
thanks for any advice
regards
Steve Goodrich


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default help with mailmerge please

Word 2003 uses a different means of connection to the data - see the Excel
data section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm
(Excel and Access have the same issue) to use the earlier connection method.
That link will also help with the mechanics of mail merge with Office 2003.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



steve goodrich wrote:
I've been using the mailmerge feature in microsoft word 97 for years,
merging with a query in Microsoft access 97. this has worked great for
years.
My company has just upgraded to Microsoft office 2003 standard. so
I've now got Word 2003 and Access 97. When I ask mailmerge to find
the data, I navigate to the access 97 query as before, but the
results show no recipients.
I've found a workround by copying the access 97 query into an excel
spreadsheet and using that as the data source but it's not ideal.
Why can't I use the access 97 query as the data source as before, or
am I missing something.
thanks for any advice
regards
Steve Goodrich



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default help with mailmerge please

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the item "Confirm conversions at open". After
doing that, when you attach the data source to the mail merge main document,
you will see a dialog asking you for the method by which the connection to
the data source should be made. The DDE option will probably be the one
that you need.

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

"steve goodrich" wrote in message
...
I've been using the mailmerge feature in microsoft word 97 for years,
merging with a query in Microsoft access 97. this has worked great for
years.
My company has just upgraded to Microsoft office 2003 standard. so I've
now got Word 2003 and Access 97. When I ask mailmerge to find the data, I
navigate to the access 97 query as before, but the results show no
recipients.
I've found a workround by copying the access 97 query into an excel
spreadsheet and using that as the data source but it's not ideal.
Why can't I use the access 97 query as the data source as before, or am I
missing something.
thanks for any advice
regards
Steve Goodrich



  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
steve goodrich
 
Posts: n/a
Default help with mailmerge please

Thanks for your help guys, I'm back in business.
"steve goodrich" wrote in message
...
I've been using the mailmerge feature in microsoft word 97 for years,
merging with a query in Microsoft access 97. this has worked great for
years.
My company has just upgraded to Microsoft office 2003 standard. so I've
now got Word 2003 and Access 97. When I ask mailmerge to find the data, I
navigate to the access 97 query as before, but the results show no
recipients.
I've found a workround by copying the access 97 query into an excel
spreadsheet and using that as the data source but it's not ideal.
Why can't I use the access 97 query as the data source as before, or am I
missing something.
thanks for any advice
regards
Steve Goodrich



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Mailmerge with Access via DDE Jim Gilligan Mailmerge 0 November 22nd 05 01:21 PM
Trying to suppress Select Table box in Excel-Word mailmerge Denise Mailmerge 4 June 21st 05 01:08 PM
Protect mailmerge document BillM Mailmerge 1 June 9th 05 12:58 PM
Included Property in Word 2003 MailMerge Alessio Mailmerge 1 December 23rd 04 11:26 AM


All times are GMT +1. The time now is 10:19 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"