#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Darlene Darlene is offline
external usenet poster
 
Posts: 11
Default Merging

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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Merging

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.


--

Graham Mayor - Word MVP

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


Darlene wrote:
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



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merging

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).

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

"Darlene" wrote in message
...
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


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging Files Frostbie New Users 5 July 8th 07 09:01 AM
Getting 0's when merging thandy Mailmerge 3 December 19th 06 01:51 PM
Merging two tables together Grd Tables 1 January 18th 06 04:25 PM
Merging?? Ivan Debono Microsoft Word Help 0 October 4th 05 03:53 PM
Merging Chris Microsoft Word Help 1 May 9th 05 05:31 PM


All times are GMT +1. The time now is 03:33 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"