View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Macros to send email automatically

Try it.

--
Regards,
Tom Ogilvy

"Jim May" wrote in message
news:Z1_If.182519$oG.163225@dukeread02...
We use an e-mail package called Groupwise;
What would one do in this case?
TIA,


"Adamaths" wrote in
message ...

Hi,

I have a feeling it depends what e-mail system you are using, but as a
starting point try the following:

ActiveWorkbook.SendMail "Recipients name", "E-Mail subject"

Replace the Recipeints name and E-Mail subject with strings that meet
these criteria.

If thaat doesn't work can you let me know what E-Mail package you are
using - Outlook, Lotus Notes etc.. and I can have another look at it.

Regards,

Adam


--
Adamaths
------------------------------------------------------------------------
Adamaths's Profile:
http://www.excelforum.com/member.php...o&userid=31580
View this thread:

http://www.excelforum.com/showthread...hreadid=513097