Multiple Lines of Data from single Heading

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pat Flynn - 15 Feb 2007 19:27 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 15 Feb 2007 19:47 GMT

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

Signature

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

> Need my merge document to include all the rows from database under same
> unit
[quoted text clipped - 10 lines]
> Thanks in advance.
> Pat

Reply to this Message

Pat Flynn - 19 Feb 2007 19:43 GMT

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

> Sounds like you are probably trying to perform a "multiple items per
> condition (=key field)" mailmerge which Word does not really have the
[quoted text clipped - 27 lines]
> > Thanks in advance.
> > Pat

Reply to this Message

Peter Jamieson - 19 Feb 2007 19:57 GMT

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

> thanks for the response Doug, The Cornell U example works just fine for
> me.
[quoted text clipped - 33 lines]
>> > Thanks in advance.
>> > Pat

Reply to this Message

Pat Flynn - 19 Feb 2007 20:37 GMT

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.
[quoted text clipped - 46 lines]
> >> > Thanks in advance.
> >> > Pat

Reply to this Message