MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel macro to send excel worksheet


Posted by Steve Arends on February 07, 2002 4:29 PM

Does anyone know how to write a macro using sendmail to send an entire worksheet (not workbook)?

Thanks


Posted by Richard S on February 07, 2002 5:49 PM

Steve,
Some time ago, I was trying to do the same thing, and looked for help here. Eventually I had to give up. My solution was to copy the worksheet to new workbook, then send that workbook. My workbook was very large and each sheet had a lot of formulae, so this ended up being slow. What I finally did was copy the contents of the worksheet into a new workbook and send that. All sorts of issues with formulae etc, but it does the job.
My macro does this for about 120 sheets, one after the other. I'm using Office 2000. My problem now is that Office now comes up with a warning for each sheet that a program is trying to automatically send an email, is this OK, and waits 5 secs before I can click Yes. What, under an older version of Office, ran automatically, now I have to click Yes 120 times, and wait 5 secs between each one. Question for you, do you know how to overcome this?

Richard

Posted by Jack in the UK on February 09, 2002 2:27 AM

Yes i agree Microsoft have not really solved this, i too have tryied [NT]