Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
millidge
 
Posts: n/a
Default Mail Merge Recipients box does not work


I was recently forced to upgrade to Office 2003 from Office 2000 (lost
original disk), which has given me no end of problems.
Primarily, the new mail merge simply does not work if I attempt to
filter more than one field in the mail merge recipients dialogue box
(either by using the drop down menu, or the ‘advanced’ filter option).
The list displays correctly in the box, but when I click OK and return
to my merge document, the correctly filtered listing appears for a
fraction of a second, then flips back to unfiltered (or
partly-filtered) data.
This has been driving me crazy. It worked perfectly well in Office
2000, and I have about a dozen different mail merge label documents,
none of which now work. I have tried rebuilding new documents from
scratch, but the merge just won’t work with my database.
Now I have an Access database with 1000 addresses which I can’t use or
filter for my magazine subscription labels and Christmas card labels,
etc.
Any advice much appreciated.

Softwa Windows XP. Word 2003. Database is Access 2003 (I even tried
converting the format from 2000 to 2003 format).

-- Gary


--
millidgePosted from - http://www.officehelp.in

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
millidge
 
Posts: n/a
Default Mail Merge Recipients box does not work


Aha. I think I may have solved my own problem by selecting the ODBC data
source instead of the default OLE DB source.
After weeks of frustration and finally registering here, I figured it
out within an hour of posting all by myself.

-- Gary


--
millidgePosted from - http://www.officehelp.in

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
clay
 
Posts: n/a
Default Mail Merge Recipients box does not work


millidge wrote:
Aha. I think I may have solved my own problem by selecting the ODBC data
source instead of the default OLE DB source.
After weeks of frustration and finally registering here, I figured it
out within an hour of posting all by myself.

-- Gary


--
millidgePosted from - http://www.officehelp.in


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
clay
 
Posts: n/a
Default Mail Merge Recipients box does not work

I am having a similar problem with filters in the Recipients box using
an Excel 2003 database. In my case it appears Word is doing something
to add additional query criteria on its own. I set up 2 conditions and
it adds 2 more when I click OK to exit from the Recipients box. The
merge is all wrong.
I am a trainer but not extremely technical. Can you give me a tip about
how I can select "the ODBC data source?"

Clay

  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
clay
 
Posts: n/a
Default Mail Merge Recipients box does not work

I found a workaround. If one saves the EXCEL workbook in CSV format,
then the filters work as expected.

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
Sending Mail Merge to Email to Multiple Recipients in the Same Mes Mark V Mailmerge 13 April 21st 23 05:06 PM
print list of mail merge recipients only....NOT the text snavehplar Mailmerge 1 November 4th 05 06:19 AM
how do I print off the list of mail merge recipients Sheila Mailmerge 1 May 10th 05 12:37 PM
Does mail merge work in the headers for Word 2003? Anita Mailmerge 1 April 12th 05 09:07 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM


All times are GMT +1. The time now is 05:38 AM.

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

About Us

"It's about Microsoft Word"