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 / March 2004

Tip: Looking for answers? Try searching our database.

XP - Problems with Mail Merge Using Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pam Owen - 14 Mar 2004 17:53 GMT
I'm having myriad problems with mail merge since I
upgraded to Office XP. My OS is Windows XP.

I have an inventory database in Acces that used to merge
easily and correctly with my Word files for labels,
invoices, etc., and now nothing works correctly. Here are
two of the biggest problems:

1. When I look at an Access table or query in Word, the
information in some fields has shifted left into the
wrong fields, producing bizarre results. I leave some of
my fields blank for various reasons, but not all
information shifts because the field to the left is
blank, and this has only started happening recently.

2. Currency values that are whole dollars do not have
trailing zeros. I can't just put in two zeros in the
field options because some prices are fractions of
dollars. These fractional amounts come over without the
final zero and with the decimal point replaced by a space.

There are more problems, but these are the most
significant ones. I'm on the verge of reinstalling Office
2000 and going back to no mail merge woes.

- Pam Owen
Graham Mayor - 14 Mar 2004 18:03 GMT
The Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm will show you how
to fix this. The issue with Access is the same as for Excel - as is the
solution.

Signature

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

     Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I'm having myriad problems with mail merge since I
> upgraded to Office XP. My OS is Windows XP.
[quoted text clipped - 22 lines]
>
> - Pam Owen
Pam - 23 Mar 2004 22:03 GMT
Thanks, Graham. I'll check it out.

>-----Original Message-----
>The Excel data section of
[quoted text clipped - 30 lines]
>
>.
 
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.