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

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

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

geniusideas wrote:
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

Word has mailing option
Why do you need macro ?

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

On Wednesday, April 24, 2013 12:16:57 AM UTC+8, witek wrote:
geniusideas wrote:

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



Word has mailing option

Why do you need macro ?

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

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

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?

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

On Tue, 23 Apr 2013 11:16:57 -0500, witek
wrote:

geniusideas wrote:
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

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.

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

CellShocked wrote:
On Tue, 23 Apr 2013 11:16:57 -0500, witek
wrote:

geniusideas wrote:
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

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.



http://office.microsoft.com/en-us/wo...001034920.aspx