Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / 3rd Party Utilities / August 2005

Tip: Looking for answers? Try searching our database.

Using Redemption and Excel: CCs, calendar items

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DFStoneJr@yahoo.com - 27 Aug 2005 04:23 GMT
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.
Alexander Gorlach - 29 Aug 2005 17:21 GMT
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/

> Windows XP, Office 2003
>
[quoted text clipped - 25 lines]
>
> TIA.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.