Re: Sending an email from Excel97
Re: Sending an email from Excel97
- Subject: Re: Sending an email from Excel97
- From: David Wignall <email@hidden>
- Date: Sat, 23 Jun 2001 17:20:51 +1200
on 22/6/01 6:59 am, Mike at email@hidden wrote:
>
Thanks for your response, Dave. Seeing that you can do it with windows, I
>
thought someone would know of a way to do it with Mac.
>
>
Mike
>
> on 21/6/01 6:46 am, Mike at email@hidden wrote:
>
>
>
>> Hi everyone. I've been all over the internet trying
>
>> to research how to send a Outlook Express email from VBAExcel. ...
>
>
>
>> Here is what I'm trying to do. if
>
>> cell (A2) is off + or - $2 then email mike with a subject "Your #1 cash
>
>> drawer is off by (A2)".
>
>
>
> If you mean attach the workbook to an e-mail message then that's the
>
> SendMail method. If you mean that you want to watch an Excel file and send a
>
> message when a certain condition is met, that's AppleScript, not VBA.
I'm not aware of _any_ mail clients on the Mac that speak VB ;) OTH VB has
the 'do script' command that lets you embed an AppleScript, So you could do
a handler in the midst of the VB, assuming you didn't want to actually
script Excel to start with... <shrug>
dave