Link to home
Create AccountLog in
Avatar of Errol Farro
Errol FarroFlag for Aruba

asked on

Split MS Word document in PDF

Good day,

I have a large MS Word document containing invoices for customers.

Each invoice is one page long and contains a row denoting customer number.

A sample invoice is

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Date:       2017-03-20
Customer number: 586
Invoice number: 25641
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


I would like to use a macro to  automatically create one page for each invoice  in PDF and have the PDF name  be the customer number? Is this possible?
Avatar of Paul Sauvé
Paul Sauvé
Flag of Canada image

just out of curiosity, does each customer have one, and only one, invoice?

If not, you will overwrite any duplicate invoices!
Avatar of Errol Farro

ASKER

Each customer has one and one invoice only
SOLUTION
Avatar of Paul Sauvé
Paul Sauvé
Flag of Canada image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
ASKER CERTIFIED SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
@Joe Winograd - the VBA solution link i provided above was written by Graham Skan who, as you well know, posts quite often on Word solutions in EE...
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
We haven't heard from the asker in four weeks, and without feedback, it's impossible to go any further. The Graham Skan solution posted by Paul has value and is worthy of some points, although, as Paul notes, it produces sequential page numbers only, NOT utilizing a value from the document, which is a key requirement for the asker (i.e., Customer Number). The method mentioned in my posts is a proven solution that I have implemented successfully in many custom programs. It is worthy, imo, of being the Accepted Solution and, along with my follow-up post, getting the lion's share of the points.