Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » VBA   (RSS)

Issue accessing Public Folder Store using CDO 1.2.1 for Outlook 2007

If you are using InfoStores collection of CDO 1.2.1 for Outlook 2007 to access Public Folder store and not able to get reference to Public Folder store then here is the explanation of the design change in CDO 1.2.1 from SGriffin’s post@ Outlook 2007,

Unable to open Outlook item attached using Attachments.Add and using the olByReference flag on the Outlook 2007

One of our customer is sending Outlook item attached using Attachments.Add with olByReference Flag on Outlook 2007. If the recipient of the email tries to open the attached item will get “Microsoft Office Oulook could not complete the operation. One or

Remove all PST from the Outlook Mailbox using VBScript

If you would like to remove all of the Personal Folders file .PSTs attached to the Outlook Mailbox profile then we can use RemoveStore Method. Here is a sample VBScript to perform the job for us: NOTE: Following programming examples is for illustration

List delegates of the Outlook Mailbox using CDO 1.2.1 via VBScript

I have recently worked out a VBScript to list delegate of the Outlook Mailbox using CDO 1.2.1 via VBScript and thought of share it with you all, here is the sample code: NOTE: Following programming examples is for illustration only, without warranty either

How to send Excel contents as PDF attachment with the email using CDOSYS

One of my customer would like to send Excel 2007 worksheet contents as email using CDOSYS. We are facing issues regarding formatting of the contents in the resultant emails on the different email clients. Then we decided to send contents as PDF attachment
Posted by brijs | 2 Comments

FYI: Test your VBA coding skills and win!

Here is a news for you… MSDN® is sponsoring a coding contest for Office 2007, named OfficePalooza ! This international contest will run for two weeks beginning April 20, 2009, and features ten fun Visual Basic of Applications™ (VBA) coding challenges
Posted by brijs | 1 Comments

Unable to use Outlook Custom form with MSFlexGrid control

One of our customer reported that they are not able to use Outlook Custom form with MSFlxGrd control after recent security update installation. When they try to open or design the form they are getting “To help prevent malicious code from running, one

Issue: Unable to set recurrence pattern of an appointment or a meeting as every weekday using Outlook Object Model

The only available recurrence patterns to set from OOM are as below: olRecursDaily = 0, olRecursWeekly = 1, olRecursMonthly = 2, olRecursMonthNth = 3, olRecursYearly = 5, and olRecursYearNth = 6. Though we can set every weekday recurrence pattern using
 
Page view tracker