Cannot populate certain UserProperties in Outlook from Excel

DNDNelson

Member
Outlook version
Outlook 2016 64 bit
Email Account
Office 365 Exchange
Hi,

I am able to highlight a comment cell in Excel, have Excel grab adjacent cell values, create and populate post in Outlook. dARCHIVED and dHIGHLIGHT are YesNo fields with OptionButton controls. From Excel, I can create the items and set their values.

I cannot setup dTASKGROUP. dTASKGROUP is a Keywords field controlled by a Dropdown ComboBox. I've tried .add, .find, setting, and the best I can do is create the item but not set the value. I've also tried specifying other stringy UserPropertyTypes with no luck.


Sub PostInOutlook()

'**Dim and Build Strings Removed for Forum Post**

Dim OutlookNS As Outlook.Namespace
Dim OutlookFolder As Outlook.Folder
Dim OutlookPost As Outlook.PostItem

Set OutlookNS = Outlook.GetNamespace("MAPI")
Set OutlookFolder = OutlookNS.Folders("someone@microsoft.com").Folders("Inbox").Folders("TASKMEISTER")
Set OutlookPost = OutlookFolder.Items.Add(olPostItem)


With OutlookPost

.Subject = z
.Body = w
.UserProperties.Add("dARCHIVED", olYesNo).Value = 0
.UserProperties.Add("dHIGHLIGHT", olYesNo).Value = 0

.UserProperties.Add("dTASKGROUP", olText) = j

.MessageClass = "IPM.Post.TaskPost100"
.Save
End With

End Sub


What am I doing wrong?

Thank you
 

DNDNelson

Member
Outlook version
Outlook 2016 64 bit
Email Account
Office 365 Exchange
Try doing is this way:

Code:
    Dim objProp As Outlook.UserProperty
With OutlookPost

    Set objProp = .UserProperties.Add("dARCHIVED", olYesNo, True)
     objProp.Value = 0
end with
I got it to work, thx! This alone didn't work, but I created the object, set new message class, saved it, then worked the userproperties and saved it again. Now it all works. Thx!
 
Similar threads
Thread starter Title Forum Replies Date
A Cannot populate IMAP folders Using Outlook 1
O Cannot expand the folder. The set of folders cannot be opened. You do not have permission to log on. Using Outlook 1
N Item cannot be saved because it was modified by another user or window, and, Item could not be moved... Using Outlook 0
D Outlook 2016 64bit, Cannot Save in 'HTML', format Using Outlook 1
D cannot view emails in View pane (in the right pane), I only see one line or nothing Using Outlook 21
M Cannot read the calendar Using Outlook 9
T The Linked Image Cannot Be Displayed in Outlook Using Outlook 7
D Outlook 2016 Outlook Error Msg "The operation cannot be performed ..." How to Stop it Using Outlook 3
S Custom Field Cannot Be Displayed In Views Outlook VBA and Custom Forms 2
G Cannot Move Autocomplete File to New Computer Using Outlook 15
rubaboo The vew cannot be found Outlook VBA and Custom Forms 0
A Cannot copy this folder because it may contain private items Using Outlook 0
L Cannot open PST file for first session each day Using Outlook 6
David in Mississippi New (Feb 2020) install of Outlook 365 - Cannot specify PST for different accounts Using Outlook 0
Marc2019 Need help please! Cannot Setup my outlook email account on my Mac Outlook 2011 Using Outlook.com accounts in Outlook 2
noshairwan Registry cannot be found, Outlook Security Using Outlook 2
Marc2019 Cannot input Vietnamese Characters on my MSOutlook 2016 in Windows 7 Using Outlook 0
T Cannot remove needless PST Using Outlook 1
Marc2019 Cannot setup Outlook Account on Mac Os 10.6.8 Using Outlook 3
N pst files are recreating automaticaly and cannot be deleted Using Outlook 5
Mark Foley Cannot enable add-in in outlook 2010 Using Outlook 0
T "cannot find the calendar folder for this item" - calendar items stuck in outbox Using Outlook 0
A Created a new user account and the local account cannot see email Using Outlook 3
iwshim outlook 2013 - I cannot see the "Manage Add-ins" Using Outlook 2
T Cannot connect to main BT email account, sub accts okay Using Outlook 0
O The page that you are trying to access cannot be loaded. Using Outlook 0
M Daily Task List Minimized Cannot Display Using Outlook 2
geofferyh Cannot get Macro to SAVE more than one message attachment??? Outlook VBA and Custom Forms 5
DariTrevino MIcrosoft Outlook PST file cannot repair Using Outlook 1
B One email cannot be sent or received (but leaves outbox!) Using Outlook 1
C Outlook 2016 cannot delete, email showing in root Exchange Server Administration 5
S Outlook.com cannot edit some contacts Using Outlook.com accounts in Outlook 5
B Search: Cannot find which Folder Contains a Message Using Outlook 3
C Outlook - cannot save subject line changes Using Outlook 2
M cannot change delivery folders with IMAP accounts Using Outlook 0
S Appointment-Cannot set Categories because ConversationID is not set Outlook VBA and Custom Forms 1
Fozzie Bear Cannot post "Sneaky URL"!! Using Outlook.com accounts in Outlook 2
Commodore Search cannot complete the indexing of your Outlook data Using Outlook 6
S Outlook 2010 Cannot Open Attachments Using Outlook 14
A Cannot Figure Out This VBA Outlook VBA and Custom Forms 2
A Cannot Figure Out One Thing on VBA Outlook VBA and Custom Forms 2
Brian Murphy Exchange Online Everything a Transport Rule should do and cannot Exchange Server Administration 1
A Error: The name cannot be matched to a name in the address list Using Outlook.com accounts in Outlook 0
K Other Shared Calendar on Outlook cannot change items Using Outlook.com accounts in Outlook 7
T Outlook 2016 cannot connect after transition to Outlook Mail Using Outlook.com accounts in Outlook 4
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
Diane Poremsky The custom form cannot be opened. Outlook will use an Outlook form instead. Using Outlook 0
T Cannot access outlook.com accounts in Outlook 2016 Using Outlook 1
T Outlook 2016 mp3 attach "this file cannot be preview because there is no previewer installed for it" Using Outlook 1

Similar threads

Top