Compatibility of 2 macros in mail merge: Delete table rows + save individual PDFs

Btop · #1 02-19-2018, 02:33 AM

Thanks Paul. In order to have the files saved with a particular name, do I need to edit the line:

Code:

StrName = .DataFields("Contact1")

Or the lines

Code:

.SaveAs FileName:=StrFolder & StrName & ".docx", FileFormat:=wdFormatXMLDocument, AddToRecentFiles:=False
      ' and/or:
      .SaveAs FileName:=StrFolder & StrName & ".pdf", FileFormat:=wdFormatPDF, AddToRecentFiles:=False
      .Close SaveChanges:=False

Thanks and sorry my ignorance

macropod · #2 02-19-2018, 02:52 AM

Quote:

Originally Posted by Btop

In order to have the files saved with a particular name, ...

That's already taken care of, via:

Code:

StrName = "Letter1 - " & Trim(StrName)

and:

Code:

.SaveAs FileName:=StrFolder & StrName(StrName)

plus the relevant .docx/.pdf extension.

Btop · #3 02-21-2018, 02:31 AM

I'm getting error 5941 with this line:

Code:

 If Trim(.DataFields("Contact1")) = "" Then Exit For

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge to create specific number of table rows	flackend	Mail Merge	4	12-01-2023 02:49 PM
Mail merge at large table with variable number of rows	blar	Mail Merge	1	10-19-2015 03:04 PM
Mail merge into table with two colums and several rows	kathriiin	Mail Merge	3	03-30-2015 07:06 AM
Mail Merge To Individual PDF Files	iamrickdeans	Mail Merge	1	01-15-2014 12:46 AM
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM