A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How list people for some modules or for all modules



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old May 28th, 2010, 05:02 AM posted to microsoft.public.word.mailmerge.fields
lemon scented
external usenet poster
 
Posts: 1
Default How list people for some modules or for all modules

A couple of related questions.

I would like to list people who are registered for each module of training.
People can register for 1, 2, 3, 4, or all 5 modules. Thus the same person
may be listed several times. If a person is registered for a module, the
module code is "1." If they are not registered, the module code is "0."

1. I tried to use the "Next record if" rule. However, the rule doesn't
seem to work very intuitively. When I select rule -- Next record if -- and
fill in "module1" equal to "1," the code «Next Record If...» is inserted.
However something like Module1 = 1 does not appear with it . It is not clear
what the "Next record if..." code does without this information. So, how
does this rule work? I can find very little useful information to help me.

2. If I could get the rule to work, how could I have something like the
following (in my simple terms). That is, what is the code to make the merge
process look through the entire list to see who is in module 1 and list them,
then go through the list to see who is in module 2 and list them, etc.

Module 1
«firstname» «lastname» [for all cases in which module1 = 1]

Module 2
«firstname» «lastname» [for all cases in which module2 = 1]

Module 3
«firstname» «lastname» [for all cases in which module3 = 1]
etc.

Also, any recommendations for references that spell out clearly how the
codes work and how to use them would be greatly appreciated. What I have
seen so far is not written in clear English so that regular people can
understand.

Thank you for any help.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:26 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.