VBA: Excel data into Word Templae

[freedavinci]

Hi, very new to VBA

How in excel with VBA can i transfer information from an Excel sheet to create a unique Word document using a template.

For example, i have a list of New Hires and their information in an Excel sheet. I need their unique information in a word template in specific places

 

[John_w]

The easiest way to do this, without needing VBA, is with a Word mail merge with the Excel worksheet as the data source.

There are many tutorials and videos to help you. Here's one:

How to mail merge from Excel to Word step-by-step

This tutorial explains how to do a mail merge from Excel to Word step-by-step, how to prepare an Excel sheet with the source data, and use shortcuts to save time.

www.ablebits.com