Thread: [Solved] Mail Merge
View Single Post
 
Old 11-03-2016, 02:27 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
The alternative would be to extract the data, similar to what you're now doing, but with all the fields for each period on a single line, then use an Excel macro to reformat the data so that the other periods are transferred to the same line.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote