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 2007

Tip: Looking for answers? Try searching our database.

Merging

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Darlene - 10 Dec 2007 18:46 GMT
I am trying to merg data from my excel 2003 sheet to form letters in word.  
To find the record I want I put in a policy # but it won't find the record.  
The # would be as such 603652.  Any suggestions as to how I can get it to
find the number I want to merge
Graham Mayor - 12 Dec 2007 10:01 GMT
It sounds as though you are trying to merge single records into a merge
letter. One easy way to do this without recourse to vba or leafing through
interminable menus is to add an ASK field and a SKIPIF field to the very
start of the merge letter. These don't print so take up no space.

If we assume that the policy number you wish to search for is in a field
called 'Number' then if you merge *all* records, the following will print
only the record that has the matching number.

{ ASK  Policy "Policy Number" \o }{ SKIPIF { Mergefield Number } <> { REF
Policy } }

You do need to ensure that {Mergefield Number} does in fact reproduce
exactly what you enter in the ASK field or they will never match.

Signature

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

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

> I am trying to merg data from my excel 2003 sheet to form letters in
> word. To find the record I want I put in a policy # but it won't find
> the record. The # would be as such 603652.  Any suggestions as to how
> I can get it to find the number I want to merge
Peter Jamieson - 12 Dec 2007 10:11 GMT
When the find record facility doesn't work, another possible approach is to
enable the Mailmerge toolbar (e.g. View->Toobars), then use the MailMerge
recipients box (3rd button from the left) to display the record list, scroll
up and down to find the record you need, then click it and close the dialog.

It's obviously not the easy search facility you need, but it probably will
work as long as your Excel sheet does not have more rows than the dialog can
hold (And its maximum is not huge - it's either 1000 or 10000 records, I
forget which off the top of my head).

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I am trying to merg data from my excel 2003 sheet to form letters in word.
> To find the record I want I put in a policy # but it won't find the
> record.
> The # would be as such 603652.  Any suggestions as to how I can get it to
> find the number I want to merge
 
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.