Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-27-2014, 07:23 AM
SW3890 SW3890 is offline Macro Windows 7 64bit Macro Office 2013
Novice
Macro
 
Join Date: Aug 2014
Posts: 3
SW3890 is on a distinguished road
Default Macro

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
Reply With Quote
  #2  
Old 08-27-2014, 07:25 AM
SW3890 SW3890 is offline Macro Windows 7 64bit Macro Office 2013
Novice
Macro
 
Join Date: Aug 2014
Posts: 3
SW3890 is on a distinguished road
Default

p.s i am using microsoft office 2007
Reply With Quote
  #3  
Old 08-27-2014, 09:05 AM
gebobs gebobs is offline Macro Windows 7 64bit Macro Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
  #4  
Old 08-27-2014, 09:14 AM
SW3890 SW3890 is offline Macro Windows 7 64bit Macro Office 2013
Novice
Macro
 
Join Date: Aug 2014
Posts: 3
SW3890 is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
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
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Needed to bold specific lines and Macro to turn into CSV anewteacher Word VBA 1 05-28-2014 03:59 PM
custom icon, undo/redo for macro, permanent macro Rapier Excel 0 08-05-2013 06:30 AM
How do I assign a macro to a button when the macro is in my personal workbook? foolios Excel Programming 2 07-27-2011 02:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft