Sendmail
 

Dear All,

I'm trying to send an workbook via email from code (actually a workbook
that contains several worksheets that I programmatically export from an
access database). I've tried attaching it to an email by using
wbk.sendmail ". The code does not produce an error, but no
email message gets sent or appears. Does anyone have any idea what is
going on?

The same occurs whether the sendmail method is called from access or
directly from within excel. By contrast the docmd.sendobject method in
access works just fine. I am using Mozilla as my mail agent, but the
same problem occurs if I set Oulook Express to be the default mail
client, so that isn't the problem.

Im am running Office XP on WIn XP Pro SP2

Thanks for your help
Malcolm

Sendmail
 

Malcolm, have a look at Ron's site here, he is the Sendmail guru
http://www.rondebruin.nl/sendmail.htm#Tips

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003

"Malcolm" wrote in message
...
Dear All,

I'm trying to send an workbook via email from code (actually a workbook
that contains several worksheets that I programmatically export from an
access database). I've tried attaching it to an email by using
wbk.sendmail ". The code does not produce an error, but no email
message gets sent or appears. Does anyone have any idea what is going on?

The same occurs whether the sendmail method is called from access or
directly from within excel. By contrast the docmd.sendobject method in
access works just fine. I am using Mozilla as my mail agent, but the same
problem occurs if I set Oulook Express to be the default mail client, so
that isn't the problem.

Im am running Office XP on WIn XP Pro SP2

Thanks for your help
Malcolm