Multiple Lines of Data from single Heading

[Pat Flynn]

Need my merge document to include all the rows from database under same unit
number. Add new merge document with info when unit number changes.
101 Hudson, WI
101 Alexandria, MN
103 Battle Creek, MI
104 New Orleans, LA
104 San Francisco, CA
Each new unit number should trigger a new mail merge document that includes
both trips for 101/104 & single record for 104.
Can the next if field accomplish this?
Thanks in advance.
Pat

 

[Doug Robbins - Word MVP]

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Pat Flynn]

thanks for the response Doug, The Cornell U example works just fine for me.
How do I format a phone numbe from excel in mail merge? I used a switch
\#(##0) ##0-###0. Doesn't work- (xxx) xxx-xxxx.
Thanks

 

[Peter Jamieson]

1. If you have spaces in your format switch you'll need to surroung the
whole format with double quotes.

2. if you /always/ want leading zeroes, use 0 rather than #

3. Within the format, you may need to surround a hyphen with single quotes

So maybe

\# "(000) 000'-'0000"

Peter Jamieson

 

[Pat Flynn]

Gracias a mi amigo. Worked well.

1. If you have spaces in your format switch you'll need to surroung the
whole format with double quotes.

2. if you /always/ want leading zeroes, use 0 rather than #

3. Within the format, you may need to surround a hyphen with single quotes

So maybe

\# "(000) 000'-'0000"

Peter Jamieson