|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 9th, 2009, 07:54 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge info into a table
I have a spreadsheet where each unique person has a handful of records
listing some classes they are teaching. I would like to present those classes in the body of a letter in row format. Is there a way to do so and include only to rows for each unique person and when the next set of rows for a new person starts it knows to produce a second letter? For example, letter would look like: Dear Person AA: You will be teaching the following classes this semester: MIS68900A MIS67900B MIS6890A Thank you for agreeing to teach. ***then the mail merge would kick off a letter for a second person Dear Person BB: You will be teaching the following classes.... HST6777C HST5567D HST7896A Thank you for teaching these classes this semester. 
|
|
#2
July 9th, 2009, 08:02 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge info into a table
Word doesn't do this "out of the box". I quote from macropod's post
earlier today: "check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it." Peter Jamieson http://tips.pjmsn.me.uk Hutch wrote: I have a spreadsheet where each unique person has a handful of records listing some classes they are teaching. I would like to present those classes in the body of a letter in row format. Is there a way to do so and include only to rows for each unique person and when the next set of rows for a new person starts it knows to produce a second letter? For example, letter would look like: Dear Person AA: You will be teaching the following classes this semester: MIS68900A MIS67900B MIS6890A Thank you for agreeing to teach. ***then the mail merge would kick off a letter for a second person Dear Person BB: You will be teaching the following classes.... HST6777C HST5567D HST7896A Thank you for teaching these classes this semester.
|
|
#3
July 10th, 2009, 09:07 AM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge info into a table
Hutch,
I don't know which versions of Excel and Word you are using nor how your "records" for each "unique" person are arranged. If they look like this in Excel: A B C D E 1 Name Class1 Class2 Class3 Class4 2 aa Hist Sci Math 3 bb Geog French Civics 4 cc Acctng Comp Art you can try this: In cell C2:E2 (assuming no one has more than 4 subjects--expand as necessary) type: C2: =IF(ISBLANK(A3),IF(ISBLANK(B3),"",B3),"") D2: =IF(ISBLANK(A4),IF(ISBLANK(B4),"",B4),"") E2: =IF(ISBLANK(A5),IF(ISBLANK(B5),"",B5),"") Select all 3 and drag the Fill Handle down as far as you have info. In Word, when you do the Mail Merge, filter the recipient list to use only those where the Name column is NONBLANKS. "Peter Jamieson" wrote: Word doesn't do this "out of the box". I quote from macropod's post earlier today: "check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it." Peter Jamieson http://tips.pjmsn.me.uk Hutch wrote: I have a spreadsheet where each unique person has a handful of records listing some classes they are teaching. I would like to present those classes in the body of a letter in row format. Is there a way to do so and include only to rows for each unique person and when the next set of rows for a new person starts it knows to produce a second letter? For example, letter would look like: Dear Person AA: You will be teaching the following classes this semester: MIS68900A MIS67900B MIS6890A Thank you for agreeing to teach. ***then the mail merge would kick off a letter for a second person Dear Person BB: You will be teaching the following classes.... HST6777C HST5567D HST7896A Thank you for teaching these classes this semester.
|
|
#4
July 10th, 2009, 03:13 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge info into a table
Sorry. The row numbers should have been as written below instead of as
written in the previous post. "Guy Lydig" wrote: Hutch, I don't know which versions of Excel and Word you are using nor how your "records" for each "unique" person are arranged. If they look like this in Excel: A B C D E 1 Name Class1 Class2 Class3 Class4 2 aa Hist 3 Sci 4 Math 5 bb Geog 6 French 7 Civics 8 cc Acctng 9 Comp 10 Art you can try this: In cell C2:E2 (assuming no one has more than 4 subjects--expand as necessary) type: C2: =IF(ISBLANK(A3),IF(ISBLANK(B3),"",B3),"") D2: =IF(ISBLANK(A4),IF(ISBLANK(B4),"",B4),"") E2: =IF(ISBLANK(A5),IF(ISBLANK(B5),"",B5),"") Select all 3 and drag the Fill Handle down as far as you have info. In Word, when you do the Mail Merge, filter the recipient list to use only those where the Name column is NONBLANKS. "Peter Jamieson" wrote: Word doesn't do this "out of the box". I quote from macropod's post earlier today: "check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it." Peter Jamieson http://tips.pjmsn.me.uk Hutch wrote: I have a spreadsheet where each unique person has a handful of records listing some classes they are teaching. I would like to present those classes in the body of a letter in row format. Is there a way to do so and include only to rows for each unique person and when the next set of rows for a new person starts it knows to produce a second letter? For example, letter would look like: Dear Person AA: You will be teaching the following classes this semester: MIS68900A MIS67900B MIS6890A Thank you for agreeing to teach. ***then the mail merge would kick off a letter for a second person Dear Person BB: You will be teaching the following classes.... HST6777C HST5567D HST7896A Thank you for teaching these classes this semester.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
