Spliting Word Mail Merge Document

Afternoon,

I am relatively new to VB and am looking to create 500+ letters. Excel file contains Names, other detail 1 and other detail 2. Problem I ran into was to be able to print 1 document (as oppose to 500+) in PDF output. I came across the code below and managed to import that into Word

Please Login or Register  to view this content.

Excel Format -

Col A - Name (used in mail merge)
Col B - Company Name (used in mail merge)
Col C - Title (used in mail merge)

However, without modifying

Please Login or Register  to view this content.

-> to

Please Login or Register  to view this content.

- I get an 4198 Error message. When I use the latter as advised on the topic, I am getting output as 1, 2, 3 etc.

I am wondering if there is any way to save these PDF outputs as the names (field 1)?

Thank you.

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Thank you.

I suggest you look in the link in the code you posted that points to where it originated...