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
  #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.


  #2  
Old May 28th, 2010, 06:09 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default How list people for some modules or for all modules

If you press ALT+F9 the fields will be toggled so that you can see their
construction.

Mail merges run from start to finish, they cannot go back to the start and
run again, so the only way you are going to merge all the records for Module
1 - and then all the records for Module 2 etc in the manner you describe is
to run separate merges for each module to new documents then combine the
contents of the documents. That would entail using five essentially similar
directory merge documents containing the single line

{SkipIf {Mergefield ModuleX} "1"}{Mergefield firstname} {Mergefield
lastname}¶

where X is the module number and ¶ means press the enter key.

Run the merge attached to your data source to a new document and it will
produce a simple list. Add a heading "Module X" and repeat for each module.
You can then insert each subsequent document at the end of the first.
http://www.gmayor.com/Boiler.htm will simplify that task if you wish.

Not strictly relevant here, but you can create a merge list based on a
particular key field - MVP Doug Robbins has developed an add-in to effect
this. See http://www.gmayor.com/ManyToOne.htm for the download link and an
explanation of its use.

Fellow MVP 'macropod' has prepared a tutorial employing a different method
based on the Microsoft support link (below), with working field codes and a
sample Excel data source which you can also download from my website
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

How to use mail merge to create a list sorted by category -
http://support.microsoft.com/?kbid=294686

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"lemon scented" lemon wrote in message
...
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 03:57 PM.


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