Excel 2007

S

shaggybob77

I have just upgraded from 2003 excel. I have a database of names, addresses
etc. in excel. I create a lot of transmittals in excel that need to be
"addressed". However i cannot create a link between my excel databse and the
excel file that i use to create transmittals/letters etc. In word it is a
simple mail merge. Any ideas on how to do it in excel 2007.
 
D

David Biddulph

Use the mail merge in Word, and ask it to use the Excel sheet as its data
source. Word help will tell you how.
 
S

shaggybob77

Thanks but i need to use the excel sheet as a data source in an excel
spreadsheet not in word.
 
D

David Biddulph

Well you haven't told us what either of your Excel sheets is doing, so you
are expecting the readers of this group to have amazing powers of ESP.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trasnmittal Generation Database 1
Using Mail Merge in Excel 2007 1
Problem With Excel 2007 - not responding and disply font changing tojapanese 1
Date filters in List for Excel 2003? 1
How do I do a "mail merge" from excel to excel? 1
Excel 2007 Forms Design 2
One Click = Multiple Cells in Excel 2007 2
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1

Top