Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Question
As part of my job, I have been assisting my boss using Word's mail merge.
While the basic functions I understand, I have an advanced question. Is it possible to group mail merge records with a given condition (In my case, people who's Last Names start with the same letter) and then move on to the next page and do the next condition (the next letter) |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Question
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 http://www.knowhow.com/Guides/Compou...poundMerge.htm -- 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 "Caleb Williams" Caleb wrote in message ... As part of my job, I have been assisting my boss using Word's mail merge. While the basic functions I understand, I have an advanced question. Is it possible to group mail merge records with a given condition (In my case, people who's Last Names start with the same letter) and then move on to the next page and do the next condition (the next letter) |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Question
For a cheap and cheerful version you could setup a merge document to do the
pages one at a time, by using ASK, REF and SKIPIF fields eg a directory merge containing the following: { ASK bChoice "Enter start letter" \o }{ SKIPIF { MERGEFIELD Last_Name } "{REF bChoice \*Upper }*" }{ MERGEFIELD Last_Name } will print a list of last names beginning with whatever start letter you respond to the ask field at the start of the merge. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Doug Robbins - Word MVP wrote: 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 http://www.knowhow.com/Guides/Compou...poundMerge.htm "Caleb Williams" Caleb wrote in message ... As part of my job, I have been assisting my boss using Word's mail merge. While the basic functions I understand, I have an advanced question. Is it possible to group mail merge records with a given condition (In my case, people who's Last Names start with the same letter) and then move on to the next page and do the next condition (the next letter) |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Question
Thanks Doug, I have printed out the links you gave me and I will look into
them tomorrow when I get to work. I'll let you know how it goes. "Doug Robbins - Word MVP" wrote: 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 http://www.knowhow.com/Guides/Compou...poundMerge.htm -- 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 "Caleb Williams" Caleb wrote in message ... As part of my job, I have been assisting my boss using Word's mail merge. While the basic functions I understand, I have an advanced question. Is it possible to group mail merge records with a given condition (In my case, people who's Last Names start with the same letter) and then move on to the next page and do the next condition (the next letter) |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Question
Thanks for the response, but this is designed to be as automated as possible
so that my current boss can run this mailmerge when I leave. If all else fails though, I have printed out your solution and will use it as a last resort. "Graham Mayor" wrote: For a cheap and cheerful version you could setup a merge document to do the pages one at a time, by using ASK, REF and SKIPIF fields eg a directory merge containing the following: { ASK bChoice "Enter start letter" \o }{ SKIPIF { MERGEFIELD Last_Name } "{REF bChoice \*Upper }*" }{ MERGEFIELD Last_Name } will print a list of last names beginning with whatever start letter you respond to the ask field at the start of the merge. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Doug Robbins - Word MVP wrote: 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 http://www.knowhow.com/Guides/Compou...poundMerge.htm "Caleb Williams" Caleb wrote in message ... As part of my job, I have been assisting my boss using Word's mail merge. While the basic functions I understand, I have an advanced question. Is it possible to group mail merge records with a given condition (In my case, people who's Last Names start with the same letter) and then move on to the next page and do the next condition (the next letter) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NO CODE - mail merge to Outlook with attachment with CC | Mailmerge | |||
Heavy Mail Merge Application | Mailmerge | |||
Can't get Word 2003 to keep data file with mail merge main documen | Mailmerge | |||
My Email Mail Merge Does Not Work | Mailmerge | |||
mail merge with word 2003 | New Users |