Thread: [Solved] Recommended solution to generate reports?
View Single Post
 
Old 03-19-2014, 02:33 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,375
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
A mailmerge can only work with one worksheet as the data source, so you would need to either:
a) consolidate the report data on another sheet for merging; or
b) use an entirely different, macro-driven process for the reporting (that process could still use Word, however).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote