Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2011, 08:25 AM
ericerler ericerler is offline Point to a specific cell Windows 7 64bit Point to a specific cell Office 2007
Novice
Point to a specific cell
 
Join Date: Aug 2011
Posts: 1
ericerler is on a distinguished road
Default Point to a specific cell

Does anyone know if there is a way to tell MS Word Mail Merge to retrieve data from a specific cell in my excel database?



In otherwords, I am using excel, but not in the typical sense where each row represents a different individual. Rather, in my database each sheet represents a different event. I want to tell mail merge to retrieve the information that is found in cell "C2" on Sheet 2 (which I renamed "Event 1").

Thanks!!!
Reply With Quote
  #2  
Old 08-11-2011, 05:31 AM
macropod's Avatar
macropod macropod is offline Point to a specific cell Windows 7 64bit Point to a specific cell 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

Hi Eric,

You can't do that. In a mailmerge, all records must be from the one worksheet, and all fields for a given record must be on the same line. For your purposes, that means you'll need to have a worksheet that has the relevant data on the rows in question (eg via the use of formulae).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mapping in Word - Point to Point Directions unistate Word 0 08-08-2011 10:04 AM
Microsoft Power Point 2004 to Office Power Point 2007 chuff PowerPoint 0 03-20-2011 01:23 PM
Insert an item to excel specific cell apjneeraj Excel 0 01-18-2011 03:39 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:20 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