Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-14-2012, 11:48 AM
cmccabe cmccabe is offline specific mail merge Windows 7 32bit specific mail merge Office 2010 32bit
Novice
specific mail merge
 
Join Date: Jun 2012
Posts: 2
cmccabe is on a distinguished road
Default specific mail merge

Is there a way to merge a specific field from excel 2010 to word 2010?

Example:

In excel 2010 a spreadsheet is saved:

ID Name Age
1 Sam 19
2 Bob 25
3 Paul 27



In word 2010:
ID1 Name Age
ID2 Name Age
ID3 Name Age
Thanks.
Reply With Quote
  #2  
Old 06-14-2012, 03:54 PM
macropod's Avatar
macropod macropod is offline specific mail merge Windows 7 64bit specific mail merge 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

It appears you're after a list, based on the ID, Name & Age of persons in your Excel workbook. A Word Directory/Catalog mailmerge can do this. It doesn't matter what other fields your Excel workbook has - the mailmerge wizard allows you to choose which fields to add to your output.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-14-2012, 04:05 PM
cmccabe cmccabe is offline specific mail merge Windows 7 32bit specific mail merge Office 2010 32bit
Novice
specific mail merge
 
Join Date: Jun 2012
Posts: 2
cmccabe is on a distinguished road
Default

Is it possible to select 4 rows in the excel spreadsheet and populate 4 seperate rows in a word document? So the Block1 row in the excel would populate the Name Age in the word document. In the first colum and Block2 would populate Name Age in the next column of the word document? Thanks
Reply With Quote
  #4  
Old 06-14-2012, 04:12 PM
macropod's Avatar
macropod macropod is offline specific mail merge Windows 7 64bit specific mail merge 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

By default, a mailmerge will process however many records you have. However, the mailmerge helper has a filtering option which allows you to choose particular records - or you can output the lot to a new file then delete the ones you're not interested in afterwards.

As you seem to be starting out, see:
http://support.microsoft.com/kb/826838
http://word.mvps.org/FAQs/MailMerge/index.htm
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
specific mail merge Mail Merge to create specific number of table rows flackend Mail Merge 4 12-01-2023 02:49 PM
specific mail merge Mail Merge to print specific record based on mergefield criterias nicnad Mail Merge 1 02-22-2012 01:53 AM
specific mail merge Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM
specific mail merge From a beginner: Mail Merge using Windows Mail mhalpern705 Mail Merge 3 12-16-2011 04:58 AM
specific mail merge Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM

Other Forums: Access Forums

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


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