How to Save File with 2 different criteria - mail merge

		Microsoft Office Forums > Microsoft Word > Word VBA
How to Save File with 2 different criteria - mail merge - individual documents vba

FAQ

Thread Tools

Display Modes

01-09-2023, 01:10 AM

Guessed

Windows 10 How to Save File with 2 different criteria - mail merge - individual documents vba

Office 2016

Expert

Join Date: Mar 2010

Location: Canberra/Melbourne Australia

Posts: 4,185

The FSName line is still inside the With .DataSource so you are saying .DataSource.DataSource.DataFields("Nomor Polis").Value

Try removing the red text from this chunk of your code

Code:

With .DataSource
.ActiveRecord = recordNumber
.FirstRecord = recordNumber
.LastRecord = recordNumber
FSName = .DataSource.DataFields("Nomor Polis").Value & " - " & .DataSource.DataFields("Nama Tertanggung").Value
End With

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail merge and saving individual documents	Freya9714	Mail Merge	1	07-05-2020 01:10 AM
Save each individual merged document as its own file	sdemuth@earthlink.net	Mail Merge	7	10-07-2019 11:21 PM
Compatibility of 2 macros in mail merge: Delete table rows + save individual PDFs	Btop	Word VBA	26	03-07-2018 01:45 PM
Mail Merge To Individual PDF Files	iamrickdeans	Mail Merge	1	01-15-2014 12:46 AM
Word Mail Merge File Save	mickeyw3340	Mail Merge	2	12-18-2012 11:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:29 AM.