Hi,
I need to create VBA in Excel to tranfer data into word template.
Here the example
In Microsoft Excel I have Data in Cell:
A1 = Date
B1 = Name
C1 = Address 1
D1 = Address 2
E1 = Address 3

I have Microsoft Word template as Below:

Date : Get Date from A1

Address 1 (Get From C1)
Address 1 (Get From D1)
Address 1 (Get From E1)

Dear Name (Get From B1)

.........

Contents...

What I need is macro in excel to automated transferring process from Excel to Word template. Thanks