Thread: need VBA to Transpose the Data from excel to word based on given criteria(status)
View Single Post
 
Old 12-19-2014, 10:21 PM
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
Your description and data suggest a mailmerge from Word. No macros required. All you need do once you've created the mailmerge main document is to apply filtering there to restrict the output to the particular records you're interested in - filtering in Excel has no effect on a mailmerge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote