How to retrieve user defined fields values to bcm form.

Status
Not open for further replies.

nisha

Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
Currently I am saving user defined fields to sql server 2008 as varbinary(512). but when I retrieving those values
to BCM form it is displaying as not correct format.
Which format we need to save user defined fields to BCM database?
 

nisha

Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
I need to save varchar(max) sql datatype data to BCM userfields column.I tried to convert varchar data to varbinary(512) following way
DECLARE @var varchar(200)
CAST(@var As varbinary(512))

I convert varchar value to varbinary and save to BCM database.But When I view this record in outlook screen,That record is not displaying correctly.Please let me know how to convert varchar value to varbinary and view correct value in outlook screen
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
P CDO MAPI Session failing to retrieve user name but Getexchage user Outlook VBA and Custom Forms 2
M Retrieve data from GAL and put it in Clipboard Using Outlook 1
M Outlook VBA Macro that could retrieve/display the (From, Subject, Date Received) Outlook VBA and Custom Forms 2
F Auto retrieve wont work Using Outlook 1
Chris Smith Outlook 2013 will not retrieve my IMAP mail Using Outlook 1
4 VBA - How to retrieve Meetings Saved but Not Sent? Using Outlook 0
K Outlook favorite folder disappear, how do I retrieve it back? Using Outlook 0
I Retrieve amount of calendar availability and attachments automatically Using Outlook 2
G Cannot retrieve emails past 2 weeks old Exchange Server Administration 1
R Went from outlook 2003 to 2010 - can't retrieve active for contacts Using Outlook 0
P Retrieve Meeting Response Text Associated with an Appointment Outlook VBA and Custom Forms 1
J Could not retrieve IMessage: Interface not supported Outlook VBA and Custom Forms 7
S Retrieve the Mails with the attachment names changed Outlook VBA and Custom Forms 3
T Re: mailItem.HTMLBody should retrieve only current text Outlook VBA and Custom Forms 1
A How to stop user form from disapearing once mail window is closed? Outlook VBA and Custom Forms 0
H Information from user defined field into Excel Outlook VBA and Custom Forms 7
D Outlook 2010 Outlook in Windows 10 keeps asking for user name and password repeatedly Using Outlook 14
E Asking user to select multiple options in a list in an email Outlook VBA and Custom Forms 0
icacream Enter your user name and password for the following server. Using Outlook 4
B User defined field for messages with 'me' in the [To], [Cc] line Using Outlook 0
S User Defined Fields adding new value (2) Using Outlook 0
R Creating a user defined function Outlook VBA and Custom Forms 3
M Compile error: User-defined type not defined Outlook VBA and Custom Forms 0
M How to export Voting Results with user names and their responses Outlook VBA and Custom Forms 13
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
C Outlook 2016 Conditional Format for User Defined Field Using Outlook 1
G <mailto:user@domain.com<mailto:user@domain.com<mailto:user@domain.com>>> Using Outlook 5
F MAPI, User Defined Fields and perspective after 20 years Outlook VBA and Custom Forms 0
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
A Created a new user account and the local account cannot see email Using Outlook 3
N How to set automatically the default or user defined Quickstyle Templates by Answer in Outlook Using Outlook 1
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
Daniel Schunk User-defined form arrives empty at the recipient Using Outlook 3
C Changed By field not displaying individual user's name in O365 Shared Mailbox Using Outlook 9
M other user's mailbox won't open, forms disappeared Using Outlook 42
S Custom user fields in received messages Outlook VBA and Custom Forms 1
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 10
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 0
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
P Change PC User Directory & iPhone Sync Using Outlook 2
J Assess content of User Defined Field in Rule Using Outlook 3
M How can I determine which user read an email Exchange Server Administration 4
J reinstalling Outlook 2007 asking for user name & password Using Outlook 14
R Prompt asking the user to send email to folder as *.msg file Outlook VBA and Custom Forms 1
J Outlook - 2013 - Error msg when copying folders from Online Archives to another user's mailbox Using Outlook 0
N Select a folder in a user account Outlook VBA and Custom Forms 2
S Outlook User defined date field (UDF) not syncing Using Outlook 2
A How to enable outlook room finder (outlook connector (mapi)) user ? Using Outlook 3
M Multiple User Defined Fields that can be added, changed, updated using VBA and user form Outlook VBA and Custom Forms 0
R User Defined Fields adding new value Using Outlook 3

Similar threads

Top