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.

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

"shaggybob77" wrote in message
...
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.

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

"David Biddulph" wrote:

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

"shaggybob77" wrote in message
...
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.

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.
--
David Biddulph

"shaggybob77" wrote in message
...
Thanks but i need to use the excel sheet as a data source in an excel
spreadsheet not in word.

"David Biddulph" wrote:

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

"shaggybob77" wrote in message
...
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.

Excel doesn't do mail merge. How did you set this up in 2003?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"shaggybob77" wrote in message
...
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.