automated way to change day/date in multiple Word table print-outs?
Vic Kamhi
this post, I am cross-posting in hopes of finding the most suitable. NO
FLAMING FOR CROSS-POSTING, THANKS!
What I want to do is print out a form from Word'97 which is a sign-up sheet
for an organization I belong to. For each day/date, I need to print out the
same form, with the new day/date combination. I need to do this for about
one-quarter's worth of forms, or 90 print-outs, the only difference in them
being the change in day/date.
I did this table in Word'97 (since we're NOT using this as a data-collection
method -- only as a form to be filled in by hand -- I saw no reason to do
this in Access or Excel!).
Last year, we only used this form for a few days, so I just changed the
day/date manually, and then printed out the form. For 90 (or more!) of
these, I'd like an automated way of doing this. In other words, I'd like to
set the start day/date combo (let's say X = day, Y = date), print out (each
table takes only a single page), increment to X+1 and Y+1 (of course, having
the day/date being correct!) print this table, and continue to X+90,Y+90.
All automatically, such that I start the process, go away, and then get 90
printouts, each with the day/date properly incremented, at the printer.
What's the best way (and I really mean the EASIEST method for one who hasn't
done too much "exotic" stuff in Word -- not necessarily the most ELEGANT) of
accomplishing this task. Does this require WordBasic, or VBA, or is there an
internal method -- something like mail merge and variable fields (tho' I'd
like to avoid manually making a list of 90 day/date combos that need to be
read), that will do this for me? Please advice. TIA.
--VIC (vmk...@hotmail.com)
--
"using Win'9X for over 1/3 of a decade"
Earl Truss
> From: Vic Kamhi <vmk...@hotmail.com>
> Newsgroups: microsoft.public.word.mailmergefields;
microsoft.public.word.tables; microsoft.public.word.word97vba;
microsoft.public.word.wordbasic
> Subject: automated way to change day/date in multiple Word table
print-outs?
> Date: Tuesday, October 13, 1998 11:10 AM
>
> What's the best way (and I really mean the EASIEST method for one who
hasn't
> done too much "exotic" stuff in Word -- not necessarily the most ELEGANT)
of
> accomplishing this task. Does this require WordBasic, or VBA, or is there
an
> internal method -- something like mail merge and variable fields (tho'
I'd
> like to avoid manually making a list of 90 day/date combos that need to
be
> read), that will do this for me? Please advice. TIA.
>
the dates you want in Excel. Just enter a couple of dates and then drag to
create all the others. Then convert your document to a mailmerge document
with merge fields from your Excel file to enter the correct date. Then
when you mailmerge the document to a new document, you'll get 90 forms with
the proper date. One gotcha that I've never figured out how to get around:
You will have to give Word the starting and ending record numbers to merge
because if you say "all" it will just keep going until some indetermine
number of records (mostly blank) have been merged.
John McGhie
You can do this two ways: as a macro, or as a mail-merge.
Doing it as a mail-merge is better, because that way you can avoid printing
useless forms for weekends and public holidays.
Having inserted your first start date in the top cell in Excell, you simply
drag the range fill handle down 90 rows to insert the other dates.
You then use a select statement (either in your mailmerge or in Excel) to
select the weekdays. Hint: Do the select in Excel: running a select in a
mail merge makes the whole thing VERY slow.
You can make a macro that simply prints the document 90 times. Word stores
its date internally as a number, so you can simply add 1 to the day number
each print. The code to extract only weekdays is a bit of a fiddle, but
there's a function in there which I think is called "IsWeekDay" made for the
purpose.
Cheers.
--
John McGhie <jo...@mcghie-information.com.au>
Consultant Technical Writer
McGhie Information Engineering Pty Ltd
Sydney, Australia (GMT +10 hrs) +61 (02) 9626 1048
Vic Kamhi <vmk...@hotmail.com> wrote in message
u2a9kRs...@uppssnewspub04.moswest.msn.net...
>Cross-post alert! Since I'm not sure which group(s) are the best target for
>this post, I am cross-posting in hopes of finding the most suitable. NO
>FLAMING FOR CROSS-POSTING, THANKS!
>
>What I want to do is print out a form from Word'97 which is a sign-up sheet
>for an organization I belong to. For each day/date, I need to print out the
>same form, with the new day/date combination. I need to do this for about
>one-quarter's worth of forms, or 90 print-outs, the only difference in them
>being the change in day/date.
>
>I did this table in Word'97 (since we're NOT using this as a
data-collection
>method -- only as a form to be filled in by hand -- I saw no reason to do
>this in Access or Excel!).
>
>Last year, we only used this form for a few days, so I just changed the
>day/date manually, and then printed out the form. For 90 (or more!) of
>these, I'd like an automated way of doing this. In other words, I'd like to
>set the start day/date combo (let's say X = day, Y = date), print out (each
>table takes only a single page), increment to X+1 and Y+1 (of course,
having
>the day/date being correct!) print this table, and continue to X+90,Y+90.
>All automatically, such that I start the process, go away, and then get 90
>printouts, each with the day/date properly incremented, at the printer.
>
>What's the best way (and I really mean the EASIEST method for one who
hasn't
>done too much "exotic" stuff in Word -- not necessarily the most ELEGANT)
of
>accomplishing this task. Does this require WordBasic, or VBA, or is there
an
>internal method -- something like mail merge and variable fields (tho' I'd
>like to avoid manually making a list of 90 day/date combos that need to be
>read), that will do this for me? Please advice. TIA.
>