Automate mail merge to save each record individually using VBA

		Microsoft Office Forums > Microsoft Word > Word VBA
Automate mail merge to save each record individually using VBA

01-05-2023, 02:31 AM

macropod

Windows 10 Automate mail merge to save each record individually using VBA

Office 2016

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

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]

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to mail merge next record on same page to save paper	klc9761	Mail Merge	1	04-22-2017 02:29 PM
Showing record number during mail merge	catflap	Mail Merge	1	04-13-2017 07:32 AM
Mail Merge Next Record If rule	RHensley	Mail Merge	10	03-07-2017 08:05 AM
Automate daily mail merge	JCInfo	Mail Merge	4	12-02-2013 05:12 PM
avoid duplicete record and merge the record with the existed record	hemant.behere	Excel	0	01-10-2012 02:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:33 PM.