Excel-Not enough memory

[olly]

Hi guys
I've got a spreadsheet which has 2 sheets-a simple first sheet which
merely looks-up data from the 2nd "raw data" sheet-which holds 48000
rows. I previously had only 10,000 records-and created a button which
basically just attaches the first sheet of the workbook and sends it
to a specified address, and that used to work fine. But since i have
increased the size of the raw data sheet to 48,000 cells, when i press
on my button to trigger the mail macro, excel comes up with 2-3
warning windows saying-"Excel Error-Not enough memory

...another thing-the whole workbook is nearly 5mb in size, but when i
use my button to start the macro to email just the first sheet-the
recipient receives a msg of which the attached sheet(just sheet 1-but
lookups work) of 600kb. So really, is this a problem with my machine
spec? because for that sort of msg to pop up when the workbook is only
5mb in size seems ridiculous !


Any feedback greatly appreciated
cheers
olly

 

[olly]

The problem also only happens when i press my button which starts the
email macro. The xls has no problem when i simply enter product codes
which uses a lookup formula to find the relevant info. So why does it
only happen when i use the email part?
Any help would be gr8ly appreciated
cheers
olly