OutlookEX UDF

[gaogao]

File 'C:\temp\Source.PST' successfully opened!
Archive 'C:\temp\Dest.PST' successfully created!
Folders successfully created!
Error copying folders. @error = 1, @extended: 1

[gaogao]

I tried specifying an existing folder in the source file:

_OL_FolderCopy($oOutlook, "\\SourcePST\ExistingFolder", "\\DestPST\Test-Folder\Sub-Test-Folder") 

Still same error.

[water]

I hope to find some spare time over the weekend to solve this problem. Please stay tuned.

[vandot]

Hi water,

great job with OutlookEX I have one problem which I can't solve for last two days. I tried more then dozen combinations for inserting inline images and result is always the same, I get image inside attachment as a attachment and inside mail I have a broken image icon.

What is correct syntax for inserting inline (embedded) images in mail?

I am using latest versions of AutoIT and OutlookEX and Outlook 2013.

Edited June 28, 2014 by vandot

[water]

Glad you like my UDF

Please check example 4 in _OL_ItemCreate.au3

[vandot]

Hi, thanks for quick response.

If I try the following code:

#AutoIt3Wrapper_AU3Check_Parameters= -d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6
#AutoIt3Wrapper_AU3Check_Stop_OnWarning=Y
#include <OutlookEX.au3>

; *****************************************************************************
; Create test environment
; *****************************************************************************
Global $oItem
Global $oOutlook = _OL_Open()
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error creating a connection to Outlook. @error = " & @error & ", @extended = " & @extended)
Global $Result = _OL_TestEnvironmentCreate($oOutlook)
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF - Manage Test Environment", "Error creating the test environment. @error = " & @error & ", @extended = " & @extended)
$oItem = _OL_ItemCreate($oOutlook, $olMailItem, "*\Outlook-UDF-Test\TargetFolder\Mail", "", "Subject=TestMail", "BodyFormat=" & $olFormatHTML, _
    "HTMLBody=Bodytext in <b>bold</b><img src='cid:The_Outlook.jpg'>Embedded image.")
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OL_ItemCreate Example Script", "Error creating a mail in folder 'Outlook-UDF-Test\TargetFolder\Mail'. @error = " & @error & ", @extended = " & @extended)
$oItem = _OL_ItemAttachmentAdd($oOutlook, $oItem, Default, @ScriptDir & "\The_Outlook.jpg") ; , @ScriptDir & "\_OL_ItemCopy.au3, 4", @ScriptDir & "\_OL_Foldertree.au3")
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OL_ItemCreate Example Script", "Error adding an attachment to a mail in folder 'Outlook-UDF-Test\TargetFolder\Mail'. @error = "  & @error & ", @extended = " & @extended)

I get the following error: Error creating the test environment. @error = 301, @extended = 3

But if comment out creating of TestEnvironment, again picture is in attachment and error in mail body.

https://dl.dropboxusercontent.com/u/3973837/Capture.PNG

Edited June 28, 2014 by vandot

[vandot]

Hi,

little update. This is very strange, it seems there is a problem with my user account, I tried on 5 PCs and still pictures are sent in attachment. But if I try from my colleagues account it is working, pictures are sent inline, on the same PC.

Thanks for help, I will investigate further problem with my account.

[water]

They all use the same version of Outlook? Are connected to the same Exchange server?

[vandot]

Yes we all use Outlook 2013 and we are all connected to the same Exchange server.

New weird just happened, if I set _OL_ItemSend($oOutlook, $oItem), to directly send mail all my colleagues successfully send mail with inline picture, but if I change that, because they demanded to, to $oItem.Display so they can first see the mail that they are going to send the picture is in attachment and broken image is in the mail body...

[water]

Looks like you first need to create the item, then add the attachment and then add the HTML code that refers to this attachment.

This works for me:

#AutoIt3Wrapper_AU3Check_Parameters= -d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6
#AutoIt3Wrapper_AU3Check_Stop_OnWarning=Y
#include <OutlookEX.au3>

Global $oItem
Global $oOutlook = _OL_Open()
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error creating a connection to Outlook. @error = " & @error & ", @extended = " & @extended)
$oItem = _OL_ItemCreate($oOutlook, $olMailItem, "", "", "Subject=TestMail", "BodyFormat=" & $olFormatHTML)
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error creating a mail in folder 'Outlook-UDF-Test\TargetFolder\Mail'. @error = " & @error & ", @extended = " & @extended)
$oItem = _OL_ItemAttachmentAdd($oOutlook, $oItem, Default, @ScriptDir & "\The_Outlook.jpg")
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error adding an attachment to a mail in folder 'Outlook-UDF-Test\TargetFolder\Mail'. @error = " & @error & ", @extended = " & @extended)
$oItem = _OL_ItemModify($oOutlook, $oItem, Default, "HTMLBody=Bodytext in <b>bold</b><img src='cid:The_Outlook.jpg'>Embedded image.")
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error modifying item. @error = " & @error & ", @extended = " & @extended)
$oItem.Display

[vandot]

Thank you

That is a solution, you have to first to attach image and then after that to create body of a mail, it makes sense. Now it is working even on my account, and I still don't understand why only me had that issue.

This is a final code, because I have to have signature attached and also I have GUI input field for single or multiple mail recipients and therefore there is a For loop in the end.

Global $aSend = StringSplit(GUICtrlRead($idSendTo), " ")
   Global $oItem
   Global $oOutlook = _OL_Open()
   $oItem = _OL_ItemCreate($oOutlook, $olMailItem, "", "", "Subject=" & $subject)
   $oItem.BodyFormat = $olFormatHTML
   $sBody = $oItem.HTMLBody
   $oItem = _OL_ItemAttachmentAdd($oOutlook, $oItem, Default, @ScriptDir & "\capture.png")
   $oItem.HTMLBody = "<body>Hi,<br><br> <img src='cid:capture.png'></body>" & $sBody
   For $i = 1 To $aSend[0]
      _OL_ItemRecipientAdd($oOutlook, $oItem, Default, $olTo, $aSend[$i])
   Next
   $oItem.Display

Thanks again.

[water]

[liamwelsh6]

hello water,

I am trying to create a script that processes tasks, i was tasting it and it all worked perfectly! However i just realized when you flag an email its not picked up in the "Get Tasks" function (as it is not a task...)

I was just wondering if there was a solution to this, or if anyone had found a way around it!

I would be happy to categorize every email that gets flagged if that provides a solution!

Thanks,

Liam

[water]

What do you mean by "Get Tasks" function?

[liamwelsh6]

; Function Name:    _OutlookGetTasks()

; Description:      Get the Tasks in Microsoft Outlook, specify Subject and/or Date Interval and/or Status to filter

[water]

I see.

You are using the "old" UDF written by Woolton.

The new UDF written by Wooltown and me doesn't have such a function. You would need function _OL_ItemFind or even _OL_ItemSearch to retrieve all tasks.

I'm not sure there is a "global way" to retrieve all tasks but I will investigate a bit ...

[liamwelsh6]

Ok, i understand.

Thank you for your quick response,

I apologize for my confusion!

I have taken your advice and it doesn't seem like you can filter items by whether they are flagged or not,

not to worry, thank you for responding!

Liam

[water]

To get a list of ALL tasks I would do the following:

• Use _OL_ItemFind to retrieve all items from the Tasks folder
• Grab all items where property IsMarkedAsTask = True (this can be Contacts, Mails or Posts)

I will have a look if there is an easier way.

[water]

By using tables it should be possible to grab all task items at once. This page describes how to do.

If needed I could translate it to AutoIt.

[liamwelsh6]

Water,

thanks for looking into this!

i think i understand the concept, i haven't got much time to look into it this evening.

Would it be possible to use anything from the old outlook UDF as that works perfectly, just only on tasks and not flagged items

Thanks,

Liam