Microsoft Office Forums Batch create word files with link to changing excel

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-22-2016, 06:36 AM
hannes.ledegen hannes.ledegen is offline Batch create word files with link to changing excel Windows 7 64bit Batch create word files with link to changing excel Office 2013
Novice
Batch create word files with link to changing excel
 
Join Date: Mar 2016
Posts: 5
hannes.ledegen is on a distinguished road
Default Batch create word files with link to changing excel

Hi,

I need to create a batch of word files which contain links to an excel file.
I have an excel file containing names and areas. I need to create a lot of word files, each file containing the name and areas of one row in excel.

e.g.
Word:
This person [NAME] has acces to [area(s)] in the year 2016.

Excel:
|NAME| AREA | AREA | AREA | AREA | AREA |
|Eric| Area 1| Area 2|
|Joseph| Area 3|
|Hannes| Area 1| Area 4| Area 7| Area 3| Area4|

The output should then be 3 word files in each of which [Name] is replaced by the name in cell A1:C1 and [area(s)] by the areas in cells B1:C5. Each word file having the content of a seperate row of the excel file.



file 1:
This person Eric has acces to Area1 and Area2 in the year 2016.

file 2:
This person Joseph has acces to Area3 in the year 2016.

file 3:
This person Hannes has acces to Area1, Area4, Area7, Area3 and Area4 in the year 2016.

Is this possible? And if yes, do you always see the [NAME] and [Areas] as if you inserted a cell or can you get just the tekst there?

Thanks in advance guys!
Reply With Quote
  #2  
Old 03-22-2016, 06:52 AM
gmayor's Avatar
gmayor gmayor is offline Batch create word files with link to changing excel Windows 10 Batch create word files with link to changing excel Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,802
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

This sounds like a Many to One mail merge - take a look at http://www.gmayor.com/ManyToOne.htm and its sample files.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 03-22-2016, 07:45 AM
hannes.ledegen hannes.ledegen is offline Batch create word files with link to changing excel Windows 7 64bit Batch create word files with link to changing excel Office 2013
Novice
Batch create word files with link to changing excel
 
Join Date: Mar 2016
Posts: 5
hannes.ledegen is on a distinguished road
Default

Thanks this is exactly what I needed! The only thing I can't figure out:

I can do everything up to making a document in which it merges several versions of the document. Perfect. Only I can't find where to get the dialog box he shows on his website in which I can select how to save to multiple files etc. I only see the "Sendlists" tab in my word which I can use to add the merge fields and all that but don't see where I open the window to finalise to several seperate files.
Reply With Quote
  #4  
Old 03-22-2016, 10:47 AM
gmayor's Avatar
gmayor gmayor is offline Batch create word files with link to changing excel Windows 10 Batch create word files with link to changing excel Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,802
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

On the first page of the add-in dialog, select Merge to Individual Word Files - http://www.gmayor.com/Images_2013/imgE.jpg
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 03-23-2016, 01:29 AM
hannes.ledegen hannes.ledegen is offline Batch create word files with link to changing excel Windows 7 64bit Batch create word files with link to changing excel Office 2013
Novice
Batch create word files with link to changing excel
 
Join Date: Mar 2016
Posts: 5
hannes.ledegen is on a distinguished road
Default

Thx for the help Gmayor, it is not so much that I can't figure out how to do it, I just cant find where to open the add-in dialog. Like the whole screen he posts all the screenshots from. All I have is an extra tool bar in word.
Reply With Quote
  #6  
Old 03-23-2016, 06:29 AM
macropod's Avatar
macropod macropod is offline Batch create word files with link to changing excel Windows 7 64bit Batch create word files with link to changing excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You don't even need an addin for this. Word's mailmerge tools and the Send Mailmerge Output to Individual Files macro in the Mailmerge Tips & Tricks thread are quite sufficient. See:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 04-06-2016, 09:25 AM
hannes.ledegen hannes.ledegen is offline Batch create word files with link to changing excel Windows 7 64bit Batch create word files with link to changing excel Office 2013
Novice
Batch create word files with link to changing excel
 
Join Date: Mar 2016
Posts: 5
hannes.ledegen is on a distinguished road
Default

Gmayor, thanks for all the help so far. Could you please tell me how to get the add-in dialog open?
Reply With Quote
  #8  
Old 04-06-2016, 11:05 PM
gmayor's Avatar
gmayor gmayor is offline Batch create word files with link to changing excel Windows 10 Batch create word files with link to changing excel Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,802
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

If the add-in is correctly installed, it adds a group to the Mailings tab of the ribbon.

Open your Letters merge document, ensure the Excel data source is attached and the document is saved. Click the Start Merge button in the add-in Group.

By default the template goes in the Word startup folder (with Word closed) If you have not changed the preferred startup folder it can be located (in English language versions of Windows) by typing
%appdata%\Microsoft\Word\Startup
in the Windows Explorer Address bar and pressing Enter.

This is all explained on the web page?
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #9  
Old 04-07-2016, 01:22 AM
hannes.ledegen hannes.ledegen is offline Batch create word files with link to changing excel Windows 7 64bit Batch create word files with link to changing excel Office 2013
Novice
Batch create word files with link to changing excel
 
Join Date: Mar 2016
Posts: 5
hannes.ledegen is on a distinguished road
Default

Thanks for all the help guys! The problem was indeed that the MailMergeManyToOne was not correctly installed. For some reason I couldn't get it to install with any of the files or methods described. So the toolbar I thought was from the ManyToOne was actually the Mailmerge tool in word. I used macropod's link, edited the macro a little and it works like a charm! Thank you very much sirs!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Batch create word files with link to changing excel Trying to create a macro to batch edit hyperlinks martinlest Excel Programming 5 01-09-2015 09:34 AM
Changing/ updating LINK from power point & excel johnseito PowerPoint 0 01-28-2014 06:31 PM
Excel 2010 changing external link formulas automatically on Webdav mapped drive dirkswart Excel 2 10-07-2013 12:44 PM
Batch create word files with link to changing excel Batch create Word documents cdfj Word VBA 6 11-07-2012 01:03 PM
Changing the slide master for a batch of presentations amac2003 PowerPoint 0 05-24-2010 11:05 AM


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


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