Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2005

Tip: Looking for answers? Try searching our database.

Mail Merge Recipients box does not work

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
millidge - 25 Nov 2005 14:56 GMT
I was recently forced to upgrade to Office 2003 from Office 2000 (los
original disk), which has given me no end of problems.
Primarily, the new mail merge simply does not work if I attempt t
filter more than one field in the mail merge recipients dialogue bo
(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 retur
to my merge document, the correctly filtered listing appears for
fraction of a second, then flips back to unfiltered (o
partly-filtered) data.
This has been driving me crazy. It worked perfectly well in Offic
2000, and I have about a dozen different mail merge label documents
none of which now work. I have tried rebuilding new documents fro
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 o
filter for my magazine subscription labels and Christmas card labels
etc.
Any advice much appreciated.

Software: Windows XP. Word 2003. Database is Access 2003 (I even trie
converting the format from 2000 to 2003 format).

-- Gar
millidge - 25 Nov 2005 15:52 GMT
Aha. I think I may have solved my own problem by selecting the ODBC dat
source instead of the default OLE DB source.
After weeks of frustration and finally registering here, I figured i
out within an hour of posting all by myself.

-- Gar
clay - 07 Dec 2005 13:55 GMT
> 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
clay - 07 Dec 2005 13:59 GMT
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
clay - 08 Dec 2005 21:13 GMT
I found a workaround. If one saves the EXCEL workbook in CSV format,
then the filters work as expected.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.