Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-10-2016, 03:25 AM
joao56777 joao56777 is offline EXCEL/WORD Document Windows 7 64bit EXCEL/WORD Document Office 2010 32bit
Novice
EXCEL/WORD Document
 
Join Date: Mar 2016
Posts: 2
joao56777 is on a distinguished road
Default 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
Attached Files
File Type: docx Chapas_1_.docx (54.6 KB, 11 views)
File Type: xlsx IC List.xlsx (93.4 KB, 10 views)
Reply With Quote
  #2  
Old 03-10-2016, 04:52 AM
macropod's Avatar
macropod macropod is offline EXCEL/WORD Document Windows 7 64bit EXCEL/WORD Document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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.
Attached Files
File Type: docx Chapas_1_.docx (50.1 KB, 9 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-10-2016, 06:21 AM
joao56777 joao56777 is offline EXCEL/WORD Document Windows 7 64bit EXCEL/WORD Document Office 2010 32bit
Novice
EXCEL/WORD Document
 
Join Date: Mar 2016
Posts: 2
joao56777 is on a distinguished road
Default

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:
Originally Posted by macropod View Post
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.
Reply With Quote
  #4  
Old 03-11-2016, 05:52 PM
macropod's Avatar
macropod macropod is offline EXCEL/WORD Document Windows 7 64bit EXCEL/WORD Document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by joao56777 View Post
What do you mean with 30 records at a time would be skipped.
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]
Reply With Quote
  #5  
Old 03-11-2016, 08:02 PM
macropod's Avatar
macropod macropod is offline EXCEL/WORD Document Windows 7 64bit EXCEL/WORD Document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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.
Attached Files
File Type: docm Chapas_1_.docm (57.1 KB, 7 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 03-13-2016, 07:15 PM
macropod's Avatar
macropod macropod is offline EXCEL/WORD Document Windows 7 64bit EXCEL/WORD Document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL/WORD Document 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft