Macro to convert Mail Merge Document to PDF

macropod · #1 12-22-2018, 09:54 PM

Quote:

Originally Posted by bearcublandon

How would I amend your code to have it look at the "Name of Participant" line for the name of the new PDF?

For that, you'd need to change:
Set Rng = .Range.Paragraphs(1).Range

to, say:
Set Rng = .Range.Paragraphs(5).Range
and change:
StrTxt = .Text
to:
StrTxt = Split(.Text,":" & vbTab)(1)
but, as I said, I'd need to see an actual document to be sure.

Quote:

Originally Posted by bearcublandon

Do you need an entire document because i could probably make one from scratch but I wouldn't be able to provide the other 34 pages in the document.

A single page containing everything down to at least the "Name of Participant" line in your screenshot would do.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert particular blocks of text within a word document to tables using macro	benbob	Word VBA	5	07-15-2018 03:20 AM
Mail Merge Macro	ch1325	Word VBA	2	06-08-2015 06:18 AM
Mail Merge Macro	spc94	Word VBA	2	06-04-2015 07:06 AM
Convert mail merge to PDF then email	TeriJean	Mail Merge	0	10-04-2011 03:52 PM
Word Doc Macro (mail Merge)	ajolson1964	Word VBA	1	05-10-2011 10:15 PM