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 / August 2003

Tip: Looking for answers? Try searching our database.

Merge w/Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sue - 27 Aug 2003 02:29 GMT
We recently upgraded from Word for Win95 to MS Office XP
Pro.  We have several forms(letters, envelopes,
certificates of service, etc.) in Word that merge with
tables in our Access database...these all converted fine
(boy were were lucky!).  However, we have several new
merge documents we need to create and when I attempt to
create one in Word that pulls information from Access, it
doesn't work.  In our old version of Word, the <<abc>>
icon was clicked and then the "find" icon.  We
were "finding" the case number field on an Access table.  
Once that field or information was located, the remaining
blank fields were merged automatically.  With the new
letter, these icons are greyed out.  It's very possible
I'm going at it from the wrong angle, but I started the
process using Tools; Mail Merge and went from there.

To top it all off, I'm a new Word user (coming from WP);
none of the current staff were employed when the original
letters were created... so, we could really use some help
and maybe a pointer to a good Word/Access reference
book!  Fortunately, I'm fairly familiar with Access... if
that helps.

Thanks for any assistance!
Peter Jamieson - 27 Aug 2003 10:21 GMT
> With the new
> letter, these icons are greyed out.  It's very possible
> I'm going at it from the wrong angle, but I started the
> process using Tools; Mail Merge and went from there.

The <<ABC>> icon should be available if the insertion point is in a mail
merge main document with a data source attached and at least one
"MERGEFIELD" field or other mailmerge field such as ADDRESSBLOCK has been
inserted into the document.

When you use the Mail merge wizard, the document would typically be in this
state once you had got to Step 4 of 6 "Write your letter" and entered one of
the things listed there, e.g. Address block, More items... etc. In step 5
you should see the new wizard's version of the "Find" facility. If you have
got beyond step 6 then you are probably looking at the /output/ of the
merge, which is not a mail merge main document, and I suspect this is what
may have happened in your case. In earlier versions of Word, you only ever
see the merge toolbar when you are looking at a mail merge main document -
the toolbar is automatically displayed for those documents, and hidden for
documents which are not mail merge main documents. In Word 2003, the toolbar
is not displayed/hidden automatically in this way, but for non-mail merge
documents only the first couple of buttons wll be available.

--
Peter Jamieson
MS Word MVP

> We recently upgraded from Word for Win95 to MS Office XP
> Pro.  We have several forms(letters, envelopes,
[quoted text clipped - 20 lines]
>
> Thanks for any assistance!
 
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.