OutlookEX UDF - Help & Support (III)

[water]

Not sure about Excel - never heard about such a problem with Excel. But I know Outlook behaves as described.

Could you test on another machine?

[Tjalve]

HAHAHA Sometimes im more stupid then usual...

I compiled the program to an EXE to run it on another system. And then it worked (on the local machine). Then i remember that i start SCITE as admin (so that i dont get any UAC prompts).. So if i skip that and just run it in the standard user mode. It works (and makes sense).

So for anyone who has the same issue as me. make sure that you run the script as the user who is running outook!

Thanks again

[water]

Great that you could solve the problem.

That is something you can find in the wiki as well:

Running script as Administrator

It seems that the process that starts or hooks into Outlook needs to be run with the same permissions as Outlook.

Edited November 27, 2014 by water

[cembry90]

Function to send mail on behalf of another person or distribution list.

expandcollapse popup

; #FUNCTION# ====================================================================================================================
; Name...........: _OL_Wrapper_SendMailBehalf
; Description ...: Creatse and sends a mail (wrapper function).
; Syntax.........: _OL_Wrapper_SendMail($oOL[, $sFrom = ""[, $sTo = ""[, $sCc= ""[, $sBCc = ""[, $sSubject = ""[, $sBody = ""[, $sAttachments = ""[, $iBodyFormat = $olFormatUnspecified[, $iImportance = $olImportanceNormal]]]]]]]]])
; Parameters ....: $oOL          - Outlook object returned by a preceding call to _OL_Open()
;                  $sFrom        - Optional: The sender
;                  $sTo          - Optional: The recipient(s), separated by ;
;                  $sCc          - Optional: The CC recipient(s) of the mail, separated by ;
;                  $sBCc         - Optional: The BCC recipient(s) of the mail, separated by ;
;                  $sSubject     - Optional: The Subject of the mail
;                  $sBody        - Optional: The Body of the mail
;                  $sAttachments - Optional: Attachments, separated by ;
;                  $iBodyFormat  - Optional: The Bodyformat of the mail as defined by the OlBodyFormat enumeration (default = $olFormatUnspecified)
;                  $iImportance  - Optional: The Importance of the mail as defined by the OlImportance enumeration (default = $olImportanceNormal)
; Return values .: Success - Object of the sent mail
;                  Failure - Returns 0
;                  |         Sets @error:
;                  |             1    - $iBodyFormat is not a number
;                  |             2    - $sBody is missing
;                  |             4    - $sTo, $sCc and $sBCc are missing
;                  |             1xxx - Error returned by function _OL_FolderAccess
;                  |             2xxx - Error returned by function _OL_ItemCreate
;                  |             3xxx - Error returned by function _OL_ItemModify
;                  |             4xxx - Error returned by function _OL_ItemRecipientAdd
;                  |             5xxx - Error returned by function _OL_ItemAttachmentAdd
;                  |             6xxx - Error returned by function _OL_ItemSend
;                  |         Sets @extended:
;                  |             -2147352567 - No permission to send email on behalf of $sFrom
; Author ........: water
; Modified.......:
; Remarks .......: This is a wrapper function to simplify sending an email. If you have to set more properties etc. you have to do all steps yourself
; Related .......:
; Link ..........:
; Example .......: Yes
; ===============================================================================================================================
Func _OL_Wrapper_SendMailBehalf($oOL, $sFrom = "", $sTo = "", $sCc = "", $sBCc = "", $sSubject = "", $sBody = "", $sAttachments = "", $iBodyFormat = $olFormatPlain, $iImportance = $olImportanceNormal)

    If Not IsInt($iBodyFormat) Then SetError(1, 0, 0)
    If StringStripWS($sBody, 3) = "" Then SetError(2, 0, 0)
    If StringStripWS($sTo, 3) = "" And StringStripWS($sCc, 3) = "" And StringStripWS($sBCc, 3) = "" Then SetError(3, 0, 0)
    ; Access the default outbox folder
    Local $aFolder = _OL_FolderAccess($oOL, "", $olFolderOutbox)
    If @error Then Return SetError(@error + 1000, @extended, 0)
    ; Create a mail item in the default folder
    Local $oItem = _OL_ItemCreate($oOL, $olMailItem, $aFolder[1], "", "Subject=" & $sSubject, "BodyFormat=" & $iBodyFormat, "Importance=" & $iImportance, "SentOnBehalfOfName=" & $sFrom)
    If @error Then Return SetError(@error + 2000, @extended, 0)
    ; Set the body according to $iBodyFormat
    If $iBodyFormat = $olFormatHTML Then
        _OL_ItemModify($oOL, $oItem, Default, "HTMLBody=" & $sBody)
    Else
        _OL_ItemModify($oOL, $oItem, Default, "Body=" & $sBody)
    EndIf
    If @error Then Return SetError(@error + 3000, @extended, 0)
    ; Add recipients (to, cc and bcc)
    Local $aRecipients
    If $sTo <> "" Then
        $aRecipients = StringSplit($sTo, ";", 2)
        _OL_ItemRecipientAdd($oOL, $oItem, Default, $olTo, $aRecipients)
        If @error Then Return SetError(@error + 4000, @extended, 0)
    EndIf
    If $sCc <> "" Then
        $aRecipients = StringSplit($sCc, ";", 2)
        _OL_ItemRecipientAdd($oOL, $oItem, Default, $olCC, $aRecipients)
        If @error Then Return SetError(@error + 4000, @extended, 0)
    EndIf
    If $sBCc <> "" Then
        $aRecipients = StringSplit($sBCc, ";", 2)
        _OL_ItemRecipientAdd($oOL, $oItem, Default, $olBCC, $aRecipients)
        If @error Then Return SetError(@error + 4000, @extended, 0)
    EndIf
    ; Add attachments
    If $sAttachments <> "" Then
        Local $aAttachments = StringSplit($sAttachments, ";", 2)
        _OL_ItemAttachmentAdd($oOL, $oItem, Default, $aAttachments)
        If @error Then Return SetError(@error + 5000, @extended, 0)
    EndIf
    ; Send mail
    _OL_ItemSend($oOL, $oItem, Default)
    If @error Then Return SetError(@error + 6000, @extended, 0)
    Return $oItem

EndFunc   ;==>_OL_Wrapper_SendMailBehalf

Edit: Added note showing that @extended=-2147352567 means you don't have permission to send that email.

Edited December 3, 2014 by cembry90

[water]

Thanks for taking the time to create this wrapper script.

Did you notice that there is a description of how to use SentOnBehalfOfName in he wiki?

[cembry90]

Thanks for taking the time to create this wrapper script.

Did you notice that there is a description of how to use SentOnBehalfOfName in he wiki?

Yep, but the functionality isn't built-in so that's why I made the wrappper. Thanks for a nice UDF btw.

[water]

I see.

The wrapper functions have been written to mimic some functions of the old Outlook UDF written by Wooltown. SentOnBehalfOfName is rarely used so I think I will not add another wrapper function to the UDF.

But having your own set of additional functions does the job as well

[anton]

Water,

I have downloaded and installed the OutlookEX.  I also looked over the Wiki and Examples. I am trying to auto populate a shared calendar with data from our ERP system.  This calendar is used by our install crew who access it via OWA on their smartphones.  We may have 30 - 70 install jobs active at any one time.  The ERP system has a SQL backend and uses Crystal for reports.  I would like the calendar to be a reflection of jobs that are active in the system.  The jobs move through production and the status changes as the job progresses.  I would like to keep the calendar up-to-date with the latest job status.  Once the job is marked complete in the ERP system I would like for the entry to be removed.

 

So here are my questions.

How would you recommend getting the data from the ERP to the shared calendar? 

Perhaps schedule a Crystal CSV report drop to a hot folder and schedule a script using OutlookEX to repopulate a fresh calendar every time.  Every 15 min would be fine.

Build a SQL query to return data to the script and then process form there?

Would you recommend rebuilding the calendar of 30-70 entries every time or a update existing entries based off CSV file or Triggered SQL changes?

Any insight is much appreciated.  Thanks for the sweet UDFs!

Anton

[water]

Just my 0.02$ worth:

• Decide how you want to store the jobs in Outlook: Appointment or Tasks (I would prefer tasks) because you can better categorize them and assign granular stati (30% done etc.)
• Do youi have a primary key to identify each job? That's needed to update the status when the next extract from your ERP has been run
• I would extract the ERP data into a flat text file (CSV or whatever) so it can easily be processed

My suggestions for the first step

More will follow after your reply.

[mdcastle]

water - please could you cast your eye on this script i'm attempting to use to access items in the Sent Items folder and possibly point out where i'm going wrong?

#include <OutlookEx.au3>
#include <Array.au3>

;Global $oSentItems = "\\Other User Mailbox\Sent Items"
Global $oSentItems = "\\Other User Mailbox"

Global $oOutlook = _OL_Open()
If @error <> 0 Then Exit MsgBox(16, "Connect to Outlook", "Error connecting to Outlook. @error = " & @error & ", @extended = " & @extended)

$aFolder = _OL_FolderAccess($oOutlook, $oSentItems, $olFolderSentMail, $olMailItem)
If @error <> 0 Then MsgBox(16, "Connect to Folder", "Error connecting to Folder. @error = " & @error & ", @extended = " & @extended)

$aItems = _OL_ItemFind($oOutlook, $aFolder[1], $olMail)

_ArrayDisplay($aItems)

After _OL_FolderAccess I get @error = 3 @ extended = 1

[TalivanIBM]

Hi!

I have a problem with the access to outlook:

Windows 8.1 64Bit

Office 2010 32Bit

When using _OL_Open() with Outlook opened can't access, no problem when outlook is closed, can I do something to solve this problem?

I use

#RequireAdmin

#AutoIt3Wrapper_Res_requestedExecutionLevel=requireAdministrator

and compile in 32 and 64 bit

Thanks!

[water]

When using _OL_Open() with Outlook opened can't access, no problem when outlook is closed, can I do something to solve this problem?

The problem is caused by #Requireadmin. Details can be found here.

[water]

After _OL_FolderAccess I get @error = 3 @ extended = 1

Could you please insert

_OL_ErrorNotify(2)

after _OL_Open?

This way we get better error information.

[GreenCan]

hi water,

Small question concerning this great udf

Is it possible to access someone else's shared calendar using below syntax?

$sAccountFolder = "Name firstNameCalendar"

$aFolder = _OL_FolderAccess($oOutlook, $sAccountFolder, $olFolderCalendar)

I always get error 3 (Error accessing specified folder), although in Outlook I can access the user's calendar as a reviewer.

I did some tests with the same colleague,

• changed from reviewer to editor
• used AD user ID
• "Name, firstNameCalendar" with added comma

All without success.

Could it be a permission issue?

In outlook, when I click on the properties of the shared calendar, I don't see a location. If I do the same on my own calendar, I see the Folderpath ( followed by my email address)

Any hint would be nice

Thanks

GreenCan

[water]

Hi GreenCan,

If you can manually access the folder it should be possible with the UDF as well.

Unfortunately I have not access to Outlook until 3rd of January next year.

Could you please try:

$sAccountFolder = "\\xxx\"
$aFolder = _OL_FolderAccess($oOutlook, $sAccountFolder, $olFolderCalendar)

xxx needs to be in the same format as the root folder (parent folder of inbox) of your account.

[GreenCan]

Hi GreenCan,

If you can manually access the folder it should be possible with the UDF as well.

Unfortunately I have not access to Outlook until 3rd of January next year.

Could you please try:

$sAccountFolder = "\\xxx\"
$aFolder = _OL_FolderAccess($oOutlook, $sAccountFolder, $olFolderCalendar)

xxx needs to be in the same format as the root folder (parent folder of inbox) of your account.

Dear water,

Brilliant, this works. Thanks. I didn't know that it was that simple. I thought that the subfolder was mandatory and I was misled because the subfolder worked with my own account.

I am surprised that it is not required for Outlook to be online with exchange to access the agenda of another user.

Enjoy your vacation.

GreenCan

 

[water]

You can access a folder by either specifying the full path (folder and subfolders) or by specifying the mailbox and one of the default folder types.

Merry Xmas and a happy new year!

Edited December 18, 2014 by water

[GreenCan]

Internet calendar access Issue

After troubleshooting with water, issue resolved!.
 
Correct syntax for Internet calendar:
Location (without the leading double slash) followed by "Name of the calendar". Both are visible if you get the properties of the calendar and if you change the name of the calendar, you have to change the name of the AccountFolder.

A few examples:

; iCal Brussels at wunderground.com
; iCal url: http://ical.wunderground.com/auto/ical/global/stations/03772.ics?units=metric&reg
$sAccountFolder = "Internet Calendars\Brussels, Belgium Weather - By Weather Underground"
_OL_FolderAccess($oOutlook, $sAccountFolder, $olFolderCalendar)

; Google iCal:
$sAccountFolder = "Internet Calendars\your-email-address@googlemail.com"
_OL_FolderAccess($oOutlook, $sAccountFolder, $olFolderCalendar)

 

Hello water,
I am struggling with following issue.  I am trying to read an Internet calendar in Outlook, created with iCal and with automatic update. I don't manage to get access using _OL_FolderAccess()
I have tried different syntaxes
name firstnameCalendarCalendarName
name firstnameInternet CalendarCalendarName
...
but I always get error 4 (extended 3 with the first one, 2 with the second one)
 
If I just download the iCal, and import it a single time.  I can access the calendar with
name firstnameCalendarCalendarName
 
I noticed following

• on flyover of the dynamicly linked  iCal calendar, I get following:

CalendarName - Internet Calendars
            url to the iCal of the user
            Last updated: time ==> which is changing of course

• flying over the imported iCal file,

CalendarName - my email address
            url to the iCal of the user
            Last updated: date and time ==> which is fixed

• When I go to Folder List, under Calendar, I only see the imported Calendar, so I guess the Internet calendar is not a folder, and that might be the reason why _OL_FolderAccess() may not be the correct method to get access to it.
• However, when I ask the properties of each of the calendars I get Type: Folder containing Calendar items for both, location: Internet Calendars for the first one and myEmailAddressCalendar for the second one.
• On my Mobile phone (a Windows device), I can synchronize the Internet calendar

Do you think it is possible to read the content of the calendar?
Found nothing on the subject on Internet unfortunately...

GreenCan
 
Thanks

Edited January 12, 2015 by GreenCan

[water]

Hi GreenCan, never tried to access an internet calendar before. Right now I am on vacation but I will have a look as soon as I return next year. If it is possible to access an internet calender from Outlook by using Visual basic then it should be possible with AutoIt as well. Happy new year to you and your familiy! water

[GreenCan]

Hi GreenCan, never tried to access an internet calendar before. Right now I am on vacation but I will have a look as soon as I return next year. If it is possible to access an internet calender from Outlook by using Visual basic then it should be possible with AutoIt as well. Happy new year to you and your familiy! water

Hi water, don't worry, I am also on vacation until 5 jan.  I have no plans to VPN every day into my Company' s Network . This can wait.

Enjoy your vacation... show in Belgium tonight, and also in the Alps I guess.

Happy new year to you and your family too.

GreenCan