#1
|
|||
|
|||
EXCEL/WORD Document
Hello,
I would like to ask you about this issue. I have a list of various materials information, in Excel IC LIST ,and i need to put in the Office Word Document, CHAPAS_1_. Because the columns in Word are paralel, and the sequence is in the column way, how can i put the information Word/Excel automatically. The correspondence formula in word don't work in this way. Could you help me about this problem? Best regards |
#2
|
||||
|
||||
If you set the attached copy of your document up for a mailmerge, you can use its preview to view & print any three records at a time. Unfortunately, because of the way the field coding needs to be set up to work with your document, it won't work properly as a normal mailmerge main document - 30 records at a time would be skipped.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
So, to do this automatically that will be dificult or i need to do make a new layout of the document.
there is impossible to do something like generate all pages with the information of Excel List. What do you mean with 30 records at a time would be skipped. Quote:
|
#4
|
||||
|
||||
if you connect the document attached to my previous post to your excel workbook for a mailmerge, then execute the merge, you'll see that the first page starts at record 1, the second at 33, and so on.
Overcoming that would require a macro.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
||||
|
||||
The attached macro-enabled version of your document contains a macro named, Merge_To_Report, which you can access via Alt-F8. If you attach the document to your workbook to use as a mailmerge data source, then run the macro, it will produce the required report.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#6
|
||||
|
||||
Cross-posted at: http://www.excelforum.com/excel-gene...-document.html
where you haven't even had the decency to acknowledge the solution provided here. For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word Document Not Opening With Excel VBA | JennEx | Word VBA | 3 | 06-20-2013 10:10 AM |
Word document in excel | BertLady | Excel | 1 | 08-02-2012 06:53 AM |
C# API to identify the uncommitted changes in Excel and Word document? | althafuddeen | Excel | 0 | 04-06-2010 07:40 AM |
Exporting word document to Excel | scaifea | Word | 1 | 01-09-2010 10:57 AM |
Connecting word and excel document | jmarin | Word | 0 | 11-28-2008 02:55 AM |