DOC Office

Portfolio

SIMULATE A MAIL MERGE

Developing functions to loop through Excel data to extract information from each record to populate a pre-created word template.

Integrating Excel with Word provides an efficient process to review and extract data from numerous records in Excel, then generate multiple Word documents in the required format.

Manually completing this task is tedious and can be very time consuming, especially if there’s numerous records to create documents from.

We design automation functions that loop through Excel data to extract information from each record (row), then populate pre-created Word documents, with the click of a button.

We’ve programmed the attached Excel sample file to create individual Word documents. You can add your own data to the Excel file and use it to generate documents of whatever type you choose. You’ll need to download both the Excel and Word files in order for the automatic population to work.

Of course we also welcome the opportunity to discuss your automation project with you – we think you’ll be pleasantly surprised by the cost and how quickly you’ll recoup your investment.

 
Download The Excel file here
Download The Linked Word file here
 

1 Comment
  • WilliamDic on May 27, 2016

    Thanks a lot for the post.Really looking forward to read more. Really Cool. Galven

Leave a Reply

Contact DOC

We welcome the opportunity to discuss your automation project or training needs with you – we think you’ll be pleasantly surprised by the cost and how quickly you’ll recoup your investment.

GET STARTED

To start the ball rolling on your automation project, call us to make an appointment.
We’ll visit you in your office, take a look at your current processes, discuss what you hope to achieve, then document our vision in a formal proposal for you to consider. It’s a risk free / fee free appointment where you have nothing to lose and everything to gain.

To make an enquiry about training your staff, call us to make an appointment.
We’ll visit you in your office, discuss your training requirements and the current expertise of your staff to devise a training package that suits you.

 

CONTACT INFO

Send a Message