View Single Post
  #1   Report Post  
Daniel
 
Posts: n/a
Default Macro to email multiple worksheets

I currently have a spreadsheet that has multiple worksheets, each used to
report information to different managers on a fortnightly basis. Currently I
manually email the worksheets, each sheet being email to a different manager.
As I email the same sheets to the same managers each fortnight I was
wondering if it is possible to use a macro to do this for me.

I am using Excel and Office 2003.