Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
nextif function examples
Would you please help me to nextif functions in Word? I am using Excel as the
data sources and merge to a Word template. My idea is to put the data record in the same merge document until the change of a field. E.g. To put all employee personal data, (name, address, birthdate, phone, etc.) on the same form and go the next page of another employee. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
nextif function examples
If you have all of that data in separate fields (columns) in the Excel data
sheet for each employee then a formletter type mailmerge will produce what you want. If you are trying to perform a "multiple items per condition (=key field)" mailmerge, Word does not really have the ability to do that: 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 Articles http://support.microsoft.com/default...b;en-us;302665 http://support.microsoft.com/default...b;en-us;294686 -- 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 "Small Potato" Small wrote in message ... Would you please help me to nextif functions in Word? I am using Excel as the data sources and merge to a Word template. My idea is to put the data record in the same merge document until the change of a field. E.g. To put all employee personal data, (name, address, birthdate, phone, etc.) on the same form and go the next page of another employee. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
nextif function examples
Hi, Doug
Thank you for your help. I do appreciate that. I did try to duplicate the steps provided by the 'Group Multiple items for a single condition' document in Cindy Meister's websit. It seems working except the "P" & "t" codes. "P" is expected to represents a parapraph mark that pushes the next project to a new line, and "t" represents a tab character that aligns the next project under the previous project. The most challenging part is how to set up for a new page automatically as the group change. "Doug Robbins - Word MVP" wrote: If you have all of that data in separate fields (columns) in the Excel data sheet for each employee then a formletter type mailmerge will produce what you want. If you are trying to perform a "multiple items per condition (=key field)" mailmerge, Word does not really have the ability to do that: 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 Articles http://support.microsoft.com/default...b;en-us;302665 http://support.microsoft.com/default...b;en-us;294686 -- 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 "Small Potato" Small wrote in message ... Would you please help me to nextif functions in Word? I am using Excel as the data sources and merge to a Word template. My idea is to put the data record in the same merge document until the change of a field. E.g. To put all employee personal data, (name, address, birthdate, phone, etc.) on the same form and go the next page of another employee. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to overwrite shortcut keys function in word | Microsoft Word Help | |||
If function and IncludePicture | Mailmerge | |||
Text to Speech Function is available in Excel but not in Word | Microsoft Word Help | |||
VBA function results in fields | Microsoft Word Help | |||
Word Compare and Merge Document Function | Microsoft Word Help |