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 / July 2007

Tip: Looking for answers? Try searching our database.

Major mail merge problems using Word 2003 and Windows XP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cdb - 06 Jul 2007 14:30 GMT
The business I work for has recently upgraded from Windows 2000 to XP and
Office 2000 to 2003. All the mail merge documents we have were created using
Office 2000.

Since the upgrade we are having major problems as follows:

The Query Criteria we enter doesn't save so we need to re-enter every time.
When we enter dates it is Americanising them (ie changing them from
dd/mm/yyy to mm/dd/yyyy)
When we finally get it to work it always pulls the first record from the
spreadsheet out regardless of the criteria - even if they shouldn't be pulled
through.

Does anyone know if these are general compatability issues, or is it
something specific to the versions our company has purchased?
Graham Mayor - 06 Jul 2007 14:45 GMT
You may find http://www.gmayor.com/mail_merge_labels_with_word_xp.htm  and
http://www.gmayor.com/formatting_word_fields.htm helpful in overcoming at
least some of the transition issues from Word/Office 2000.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> The business I work for has recently upgraded from Windows 2000 to XP
> and Office 2000 to 2003. All the mail merge documents we have were
[quoted text clipped - 11 lines]
> Does anyone know if these are general compatability issues, or is it
> something specific to the versions our company has purchased?
cdb - 06 Jul 2007 15:22 GMT
Brilliant - that's helped me with the dates, so thanks a lot. On the first
link you have below, I tried to follow that and when I click to link to Excel
via DDE, it said it couldn't connect that way - is this a normal problem and
is there an easy solution?

Cheers.

> You may find http://www.gmayor.com/mail_merge_labels_with_word_xp.htm  and
> http://www.gmayor.com/formatting_word_fields.htm helpful in overcoming at
[quoted text clipped - 15 lines]
> > Does anyone know if these are general compatability issues, or is it
> > something specific to the versions our company has purchased?
Peter Jamieson - 06 Jul 2007 16:38 GMT
What exactly does the error message say?

If it says "Word could not re-establish a DDE Connection to Microsoft Excel
to complete the current task", the first thing to check is that you have not
checked Excel Tools|Options|General|"Ignore other applications"

NB, although all your existing applications should work, assuming that you
always used DDE (the default in WOrd 2000), the DDE method only lets you
connect to the first sheet in a workbook.

Peter Jamieson

> Brilliant - that's helped me with the dates, so thanks a lot. On the first
> link you have below, I tried to follow that and when I click to link to
[quoted text clipped - 25 lines]
>> > Does anyone know if these are general compatability issues, or is it
>> > something specific to the versions our company has purchased?
cdb - 06 Jul 2007 17:00 GMT
That's the message. I think I've got around the problem now though. For some
reason a buch of the letters still worked, so I'm using those as a template
and it seems to have solved the problem. A little strange, but I can live
with that.

Thanks for all the help.

> What exactly does the error message say?
>
[quoted text clipped - 37 lines]
> >> > Does anyone know if these are general compatability issues, or is it
> >> > something specific to the versions our company has purchased?

Rate this thread:






 
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.