Hi matt,
A limited amount of conditional formatting is possible via mailmerge but, if
your form is entirely Excel-based, that's not going to help much.
Depending on how your data are structured, it might be possible for you to
insert a formula in each of the cells on your data-request form that uses an
OFFSET function to pull data from a given row on your data sheet. Something
in the form of:
=OFFSET(Data!$A$1,Row,Col)
where Col refers to the column number (minus 1) for the field and Row refers
to the row number (minus 1) for the record.
Then, all you need to do is to change the row value to get all the OFFSET
formulae to look at a given set of records. For that, you could use a 'seed'
cell with hidden text (eg white on white) on your data-request form or one
outside the form's print area, to select each record in turn.
You could even use a macro to count he number of records on your data sheet
run a loop to update your 'seed' cell and print each record in turn.
Of course, you could also code the whole of the above into a macro and
dispense with formulae altogether. Horses for courses, as they say.
Cheers
--
macropod
[MVP - Microsoft Word]
mattgoof2005 said:
I can't keep my conditional formatting if I do that. I'd like to keep it in
excel if possible.
macropod said:
Hi,
you data-request form is a Word document, a mailmerge is a possibility,.
Cheers
--
macropod
[MVP - Microsoft Word]
mattgoof2005 said:
I have a table with lots of data( department number, name, manager,
etc.)
I
also have a data-request form I want to print off for all of those
departments. What's the best way to transfer all that data to the
forms
and
print off one for each deparmtment?
