Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 142
  • Last Modified:

How can I automate this printing procedure?

I have a client that is an insurance company looking to make their lives easier. They have 3 separate documents that each use a mail merge (50-75 people at a time on average).

* There's an "initial letter" which just has name and address.
* There's an auto quote page that generates an auto quote and even puts pictures of this specific person's cars.
* There's a final page with a home owner's quote that is specific to this person's home.

These three documents are separate files. Is there a way to create a macro or SOMETHING that can take the three pages for each person and turn it into a single document?


We want to be able to print all 50-75 people's documents and just "pick them up". We would ideally like to get a large office printer that has the sort/collate function so each person's documents are separated from the next.
  • 2
2 Solutions
The only real problem is getting the quote data into the merge database. How are the quotes generated?
For example, can you create a CSV or XLS file? That can then also be merged.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now