View Single Post
  #2  
Old January 8th 07, 05:15 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default email from excel cell

An email can't execute code to change the current folder. You would have to
write code that runs on each computer that will receive the emails that
identifies the emails and sets the ActiveExplorer.CurrentFolder object.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Ben" wrote in message
...
I know I can get excel 2003 to send an email with cc, bcc, subject and body
from a
cell by entering the follwing statement into that cell:

Subject%20Message&cc=e-mail address;&bcc=e-mail address;&body=Text%
20of%20the%20message

When I send this email the recipients will receive the email with the
message "Text of the message", in outlook

What I want to do is to send as an email, from a cell in excel, an
"OutLook
Task" and an "OutLook Appointment", such that when the recipient opens the
the email outlook will open to the Task module or the Appointment mudule,
which they can then save to outlook

Needless to say, the information send via the excell link will be very
small

The email will open to outlook's Task or Appointment

I am looking for a statement that will allow me to do this...
Please
Thanks


Ads