Cannot populate certain UserProperties in Outlook from Excel

Status
Not open for further replies.
D

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
 
Diane Poremsky said:
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
Click to expand...
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!
 
Status
Not open for further replies.
< Button PDF in Outlook Contact custom form | VBA to save selected Outlook msg with new name in selected network Windows folder >
Similar threads
Thread starter Title Forum Replies Date
A Cannot populate IMAP folders Using Outlook 1
G Cannot receive emails from gmail account in Outlook 365 Using Outlook 1
E "Cannot display the folder. MS Outlook cannot access the specified file location" Using Outlook 7
Rupert Dragwater Cannot reestablish gmail (email address) account in Outlook 365 Using Outlook 11
E "The operation cannot be performed because the message has been changed" Using Outlook 3
T Cannot open .pst file Using Outlook 2
D Outlook 365 Outlook Message "Cannot be sent because the message has changed" Using Outlook 0
P Cannot understand how to use Favorites Using Outlook 4
U When opening shared Calendar "The set of folders cannot be opened" Using Outlook 0
J Cannot edit a calendar event received as an invitation Using Outlook 2
humility36 Cannot move emails to archive - 440 error Outlook VBA and Custom Forms 1
L I Cannot Sign Into My Outlook Account? Outlook VBA and Custom Forms 0
CWM330 This rule has a condition that the server cannot process? Using Outlook 1
U Outlook on the iPhone cannot approve filtered Emails Using Outlook 0
Horsepower Cannot delete gmail in iPhone Outlook outbox Using Outlook 1
K Daily Task List Minimized Cannot Display Using Outlook 5
O The linked image cannot be displayed Using Outlook 2
C "The linked image cannot be displayed. The file may have been moved, renamed, or deleted. Verify that the link points to the correct file location" Using Outlook 1
B IMAP server rejects sent email - cannot deliver messages Using Outlook 2
T Outlook 2021 Cannot open attachments Outlook DeskTop 2021 Using Outlook 0
S Cannot print Contacts Using Outlook 7
J VBA Cannot programmatically input or change Value for User Defined field Using Outlook 1
T Outlook 2010 Cannot edit Calendar entries in OL 2010. 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 4
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

Similar threads

Back
Top