How to make a variable selection to print?

  • Thread starter Thread starter Hans Hommes
  • Start date Start date
H

Hans Hommes

Good morning,

In a excel sheet I have 12 monthly sheets (january to december) and a total
sheet. Names and shifts are enterd into the monthly sheets, which are then
by formula copied to the total sheet. The total sheet is sorted in
alphabetical order by name. Then the information per name should be copied
into a standard-letter. My problem, that in totalsheet there are not the
same number of lines (it varies from 1 to 4) per name. So I don't know how
to solve this with mail/merge. Is there a solution?

I use Office XP.

Every help is welcome, thanks already,
Hans
 
When I've ever done mailmerge (not that often!), I try to put my data on one
row.

Any chance you could take those 4 rows and put them on one?
 
Thats's part of the problem. I don't know in advance wether a name (member)
has 1, 2, 3 or 4 shifts to fullfill. So i don't know how many lines to fill
in the letter
 
Whenever I have questions about mailmerge, I look at one of these:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

In fact, I went to the Beth Melton/Dave Rado site and one of the links on that
first page showed this:

Making your mail merge “intelligent” by using If Fields
http://word.mvps.org/FAQs/MailMerge/MMergeIfFields.htm

You may find it interesting and helpful.
 
Also, Word MVP, Cindy Meister, has information about mail merge on her
web site:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Look under the heading 'Special Merges' for 'Multiple Items per Condition'


Dave said:
Whenever I have questions about mailmerge, I look at one of these:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

In fact, I went to the Beth Melton/Dave Rado site and one of the links on that
first page showed this:

Making your mail merge “intelligent” by using If Fields
http://word.mvps.org/FAQs/MailMerge/MMergeIfFields.htm

You may find it interesting and helpful.
Click to expand...
 
Back
Top