Point to a specific cell

[ericerler]

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!!!

[macropod]

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).