Tranfer data from Excel to word (Docx) via VBA in Excel

[geniusideas]

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)

RE:.........

Contents...

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

 

[witek]

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)

RE:.........

Contents...

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

Word has mailing option
Why do you need macro ?

 

[geniusideas]

Word has mailing option

Why do you need macro ?

Sorry, because I have very long list of name in excel.

 

[Kalyan Kuppachi]

are you looking at creating a document for each of the entry in the list ? Will the content of the document will be same for all mailers?

 

[CellShocked]

Word has mailing option
Why do you need macro ?

I can tie "fields" or line entries in a word document to an excel
spreadsheet?

So I have a word document and I have a spreadsheet version.

How do I make those 'field' assignments in word, and how do I send the
excel data to it?

Right now, we print the word doc, and it gets filled out by hand.
Then re-transcribed into the computer. Lost labor.

Heck, I can't even get the data into word without it deleting the
"underline" in the area where I put the data, so I suspect the document
creator is not making the document the "right way' either.

 

[witek]

I can tie "fields" or line entries in a word document to an excel
spreadsheet?

So I have a word document and I have a spreadsheet version.

How do I make those 'field' assignments in word, and how do I send the
excel data to it?

Right now, we print the word doc, and it gets filled out by hand.
Then re-transcribed into the computer. Lost labor.

Heck, I can't even get the data into word without it deleting the
"underline" in the area where I put the data, so I suspect the document
creator is not making the document the "right way' either.

http://office.microsoft.com/en-us/w...e-a-walk-through-the-process-HA001034920.aspx