Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-12-2018, 05:09 AM
rhvanloenen rhvanloenen is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2018
Posts: 1
rhvanloenen is on a distinguished road
Default merging in Excel with excel but want also merge files

I have a portfolio for students and data for that I get from an exported Excel file.



Each student has also written his own information and saved that file under his / her student number.

That student number corresponds to the student number from the excel file.

The problem now is that when merging, I also have to include the file of that particular pupil in the documnet and that of course in the merge for all pupils.

Merging is no problem, but per student's own file also insert.

How should this be?

Can someone help?
Reply With Quote
  #2  
Old 01-12-2018, 06:47 AM
Charles Kenyon Charles Kenyon is offline Windows 10 Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 5,447
Charles Kenyon is a glorious beacon of lightCharles Kenyon is a glorious beacon of lightCharles Kenyon is a glorious beacon of lightCharles Kenyon is a glorious beacon of lightCharles Kenyon is a glorious beacon of lightCharles Kenyon is a glorious beacon of light
Default

Mail Merge from two Excel files with common ID#?
Reply With Quote
  #3  
Old 01-12-2018, 12:42 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,671
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

What is the 'particular pupil' file - a Word document, or another Excel workbook? If it's an Excel workbook, what is its layout?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging multiple CSV files into a new EXCEL workbook Alex99 Excel Programming 2 10-30-2017 03:34 PM
Word does not put the files in the outbox of Outlook (merging with excel fields) Pannemanski Mail Merge 1 04-08-2016 03:58 AM
Merge Excel files Balas Excel 4 07-02-2012 06:09 AM
How can I merge different excel files into one? Kaloyanski Excel 3 11-02-2011 02:47 AM
Merging word files from excel macro hklein Excel Programming 0 08-05-2011 02:27 AM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft