Thread: [Solved] Automate mail merge to save each record individually using VBA
View Single Post
 
Old 01-05-2023, 02:31 AM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
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
Simply include both data fields in the sFName variable...

For example:

sFName = .DataFields("Surname").Value & ", " & .DataFields("Namee").Value
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote