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

G

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
 
W

witek

geniusideas said:
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 ?
 
K

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?
 
C

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.
 
W

witek

CellShocked said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top