OutlookEX UDF

437 posts in this topic




Posted

This is a nice implementation, it will make the maintenance of the code easier in the future and hopefully less errors.

Share this post


Link to post
Share on other sites

Posted

Hi Water

Did you attach the UDF or provide a link?

Crayfish likes this

Share this post


Link to post
Share on other sites

Posted (edited)

---

Edited by Wooltown

Share this post


Link to post
Share on other sites

Posted (edited)

Hi Water

Did you attach the UDF or provide a link?

Not yet.

As a first step we wanted to discuss the concept and gather requests from the community.

Then in a second step we wanted to provide the code we have so far for playing and testing .

The functions available so far can be found in the attached thumbnail.

Or do you think we should post the code right now and then talk about it?

Edited by water

Share this post


Link to post
Share on other sites

Posted

No, this is great, my mistake.

Seems like you two have done some good prep-work already and are well on your way to having it done. I'm very interested in supporting this project, let me know how I can help.

Your approach seems sound. I have an idea that may or may not fit into your plans.

An Is-busy function. Essentially a query for a calendar whether a specific timeslot has a scheduled appointment or not. This may seem easy, however when you query a calendar you get all entries in the calendar and the reoccurence type etc. can cofuse things pretty quickly.

Not on your list, There is also an appointment item "conflict" that can be queried (if two things are scheduled at same time)

I have a pretty good VBA function for item2task if you want a copy....I see you have it listed as unfinished.

Anyways, I'll keep tabs on this post and see what develops. Looking forward to seeing your work.

Picea892

Share this post


Link to post
Share on other sites

Posted

Hi Picea892,

An Is-busy function. Essentially a query for a calendar whether a specific timeslot has a scheduled appointment or not. This may seem easy, however when you query a calendar you get all entries in the calendar and the reoccurence type etc. can cofuse things pretty quickly.

The _OL_RecipientFreeBusyGet function should do what you want. It answers a question like "Does John Doe have some free time today between 09:00 and 11:00 for a 30-minute meeting?" You use _OL_RecipientFreeBusyGet to query the user for the interval in steps of 30 minutes and get a string where each character represents 30 minutes. Each character shows if the user is free, busy or whatever.

Not on your list, There is also an appointment item "conflict" that can be queried (if two things are scheduled at same time)

Good idea, I will put it on the todo list.

I have a pretty good VBA function for item2task if you want a copy....I see you have it listed as unfinished.

If you like you can post it here or send it to me via PM.

I think we will post some code to play with as soon as we have the example scripts finished for every function.

Share this post


Link to post
Share on other sites

Posted (edited)

OK, here is something for you to play with. Be aware that it's an early alpha version!

  • Every example script (except the _OL_BarXXX scripts) delete and recreate a folder "Outlook-UDF-Test" plus subfolders and items in your inbox. So every example script has the same test environment
  • The _OL_BarXXX scripts create groups and shortcuts in your OutlookBar. The delete functions aren't available yet - so you have to delete them yourself
  • The scripts have been written and tested with Outlook 2002 SP3 on Windows XP SP3 - don't know if they all run with newer Outlook versions
  • One wrapper function _OL_MailSend has been finished. It puts together the necessary function calls to send an EMail - just to simplify live!
  • The OutlookEx.pdf lists the available functions. All _OL_ItemXXX functions list for which type of item they are available (mail, appointment ...)
Please first start _OL_TestEnvironment.au3 to set up the test environment (at least set the "Don't ask" flag).

Please report any errors you find.

Happy testing.

Edited by water

Share this post


Link to post
Share on other sites

Posted

Thank you very much :-)

I'll be playing with tasks.

I can assume that when the beta of the release version comes out, the name of functions like _OL_ItemFind won't change ?

Keep going!

Share this post


Link to post
Share on other sites

Posted (edited)

Hi Vampie,

correct - the function names will not change. But maybe the number or order of parameters, the return values of the function or whatever seems to make sense.

If you get errors, need more documentation or better examples, or if functions are missing: just drop me a note!

Happy testing!

Edited by water

Share this post


Link to post
Share on other sites

Posted

Two functions that I missed in the previous UDF were sentonbehalf and send with delay. I've added the following myself in the old Outlook UDF.

	$oMessage.DeferredDeliveryTime = $sDelay
	$oMessage.Sentonbehalfofname = $sFrom

I don't know if anyone else will use these functions, but they helped me out :)

Share this post


Link to post
Share on other sites

Posted (edited)

With the new UDF you can pass this properties to the _OL_CreateItem function:

; Create a html mail plus two attachments. 
; Set the properties to send on behalf and send deferred.
; *****************************************************************************
$oItem = _OL_ItemCreate($oOutlook, $olMailItem, "*\Outlook-UDF-Test\TargetFolder\Mail", "", _
"Subject=TestMail", _
"BodyFormat=" & $olFormatHTML, _
"HTMLBody=Bodytext in <b>bold</b>.", _
"DeferredDeliveryTime=" & $sDateTime, _
"Sentonbehalfofname=" & $sFrom)
Edited by water

Share this post


Link to post
Share on other sites

Posted

Oh very nice. I'm really glad that you guys are improving this UDF. I would really like to make a contribution but I'm afraid that my programming skills are not good enough (yet). I do want to wish all of you guys goodluck with this project.

Share this post


Link to post
Share on other sites

Posted (edited)

Hi Rigest,

if you want to add something to this little UDF then you could do some testing, report spelling or grammatical errors (as you will have noticed neither wooltown nor I are native speakers), tell us about missing functions etc. etc.

The UDF is very modular but on the other hand you could need to call 5 or 6 functions to get a task done. We now write some wrapper functions that make it easier for the beginner to get a task done.

_OL_Wrapper_MailSend is available so far. If you need further wrapper functions, please let us know.

Edited by water

Share this post


Link to post
Share on other sites

Posted

42 downloads and no comments :)

Don't be shy, post what you think about the UDF, what you like, what you don't like, what's missing etc. etc. ......

We need your input to improve the UDF ...

Share this post


Link to post
Share on other sites

Posted (edited)

Version 0.0.3 has been released.

Please test before using in production!

For download please see my signature.

Edited by water

Share this post


Link to post
Share on other sites

Posted (edited)

Sorry wrong place to put this

Edited by Autobot

Share this post


Link to post
Share on other sites

Posted

Version 0.1.0 has been released.

Please test before using in production!

For download please see my signature.

mrpingis likes this

Share this post


Link to post
Share on other sites

Posted

Can someone post an example of this UDF adding a contact and show full list of contacts? Thanks for the help.

Share this post


Link to post
Share on other sites

Posted

1) Adding a contact: Please have a look at _OL_ItemCreate.au3 - example number 2

2) Show full list of contacts: Please have a look at _OL_ItemFind.au3 - example number 1. If you replace '[FirstName] = "TestFirstName"' with "" you should get all contacts of the specified folder.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now