Thread: make a form that can be used multiple times at once
View Single Post
 
Old 03-24-2013, 01:59 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Deb,

Yes, you do need to save the Excel file - mailmerges only work with what's in a saved file. I also note from the workbook attached to your previous post that you seem to be trying to use separate workbooks for each school. With the proper setup, you can have records for multiple schools spanning multiple years all in the one workbook. Basically, all it requires is the application of some filtering.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote