Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple Lines of Data from single Heading
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple Lines of Data from single Heading
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/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;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" wrote in message ... 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple Lines of Data from single Heading
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 "Doug Robbins - Word MVP" wrote: 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/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;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" wrote in message ... 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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple Lines of Data from single Heading
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" wrote in message ... 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 "Doug Robbins - Word MVP" wrote: 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/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;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" wrote in message ... 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 |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple Lines of Data from single Heading
Gracias a mi amigo. Worked well.
"Peter Jamieson" wrote: 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" wrote in message ... 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 "Doug Robbins - Word MVP" wrote: 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/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does a single mouse click select multiple lines? | Microsoft Word Help | |||
Single document, multiple (auto) heading styles | Page Layout | |||
Combining multiple data lines for same company to single MS Word d | Mailmerge | |||
Single Toc Item from Two Heading Lines | Microsoft Word Help | |||
Convert multiple lines of text to a single cell in a table | Tables |