| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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?
|
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I work in excel and then save it as a doc or docx? | New Users to Excel | |||
| Tranfer of data via v &/or h lookup | Excel Worksheet Functions | |||
| How can we tranfer data from iSeries in MS-Excel 2003 with SP2? | Excel Worksheet Functions | |||
| How can we tranfer data from iSeries in MS-Excel 2003 with SP2? | Excel Programming | |||
| Macros to tranfer data to database | Excel Discussion (Misc queries) | |||
Linear Mode
