Thread: Email question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Email question

No. Sendmail is a single command - it doesn't offer choices or interaction.

If you want to interact with the user, you will need to program that
interface. Put up the choices in a dialog, then put the selection in the
array and do sendmail. Or you can get more sophisticated by programming
the Outlook object model if you wish. See Ron de Bruin's site for some
discussion.

http://www.rondebruin.nl/sendmail.htm

Dick Kusileka also has some information:
www.dicks-clicks.com


--
Regards,
Tom Ogilvy


"olly" wrote in message
...
Ok thanks-but can you put for instance
.SendMail Array(" ", "),

what i want it to do is auto put someone in the sending
list, but not to send the mail until the user selects
another person from the address book. Is this how you do
it ? doesn't seem to be working when i try it..
any help very much appreciated
cheers
olly


-----Original Message-----
Sendmail doesn't make that distinction (or offer that

option). You can send
to multiple people with

..SendMail Array

"),
"Confirmation - "

Regards,
Tom Ogilvy