Help!

Using Redemption and Excel: CCs, calendar items

 
  

Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> 3rd Party Utilities RSS
Next:  Attachments are being blocked in email through KW..  
Author Message
DFStoneJr
External


Since: Sep 14, 2005
Posts: 3



PostPosted: Fri Aug 26, 2005 8:23 pm    Post subject: Using Redemption and Excel: CCs, calendar items
Archived from groups: microsoft>public>outlook>thirdpartyutil (more info?)

Windows XP, Office 2003

I'm currently using variations of the following Excel VBA code to send
e-mails through Outlook from Excel via the Redemption add-in:

Sub SendSafeitem()
Set objOL = CreateObject("Outlook.Application")
Set Namespace = objOL.GetNamespace("MAPI")
Namespace.Logon
Set SafeItem = CreateObject("Redemption.SafeMailItem") 'Create an
instance ofRedemption.SafeMailItem
Set oItem = objOL.CreateItem(0) 'Create a new message oItem.Save
FiletoSend = Sourcedir & FiletoSend
SafeItem.Item = oItem 'set Item property
SafeItem.Recipients.Add Recipients
SafeItem.Subject = Subject
SafeItem.Body = Body
SafeItem.Send
Set objOL = Nothing
Set oItem = Nothing
End Sub

Is it possible, with or without Redemption, to:
1) add an attachment to the message,
2) add CC recipients rather than TO: recipients; and
3) add an item based on the message being sent to the Outlook calendar
(e.g., a task to follow-up on the item at a certain date and time)?

TIA.
Back to top
Alexander Gorlach
External


Since: Oct 05, 2004
Posts: 32



PostPosted: Mon Aug 29, 2005 8:21 pm    Post subject: Re: Using Redemption and Excel: CCs, calendar items [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi,

you can also try Outlook Security Manager:
http://www.add-in-express.com/outlook-security/

It is very simple component: you'll able to turn on/off all security in
Outlook by one call, and to use all "protected" methods of Outlook API
without warnings. Outlook API is single-thread, so using of this component
will not affect the global security.

Alexander Gorlach,
MAPILab Ltd.
http://www.mapilab.com/outlook/


<DFStoneJr RemoveThis @yahoo.com> wrote in message
news:1125113037.059716.57590@g14g2000cwa.googlegroups.com...
> Windows XP, Office 2003
>
> I'm currently using variations of the following Excel VBA code to send
> e-mails through Outlook from Excel via the Redemption add-in:
>
> Sub SendSafeitem()
> Set objOL = CreateObject("Outlook.Application")
> Set Namespace = objOL.GetNamespace("MAPI")
> Namespace.Logon
> Set SafeItem = CreateObject("Redemption.SafeMailItem") 'Create an
> instance ofRedemption.SafeMailItem
> Set oItem = objOL.CreateItem(0) 'Create a new message oItem.Save
> FiletoSend = Sourcedir & FiletoSend
> SafeItem.Item = oItem 'set Item property
> SafeItem.Recipients.Add Recipients
> SafeItem.Subject = Subject
> SafeItem.Body = Body
> SafeItem.Send
> Set objOL = Nothing
> Set oItem = Nothing
> End Sub
>
> Is it possible, with or without Redemption, to:
> 1) add an attachment to the message,
> 2) add CC recipients rather than TO: recipients; and
> 3) add an item based on the message being sent to the Outlook calendar
> (e.g., a task to follow-up on the item at a certain date and time)?
>
> TIA.
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> 3rd Party Utilities All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum