im doing an invoice at work i would like to print of 3 invoices that nearly the same but on one invoice it has delivery note other has customer copy and last one to have accounts

is their a way to just print once and 3 pieces of paper to come out

page 1 to say delivery note
page 2 to say customer copy
page 3 to say accounts




ive recorded a macro so i can change it just by pressing ctrl D, ctrl C and ctrl A

p.s i am using microsoft office 2007

Just off the top of my head, you could have the three on separate tabs with the common fields for two populated by the third.

Thanks i try that tomorrow i just want a way that if i click print once it print of 3 copies the same only difference is delivery note. Customer copy and accounts