BC (SaaS) - Populate custom fields from standard Outlook email message

Damjan
Member Posts: 94
Hi All,
How to populate custom fields displayed on Page - "Create Interaction" with standard fields from Outlook e-mail message?
I cannot figure out how to map field ("Subject", "From", "Sent") of the email message to custom field ("Mail From", "Mail To", Mail Received On", etc.).
Business Case: As email message is received, Sales Manager reads the received email message and creates an interaction, where the process should be automatized as much as possible.
Solution: BC Outlook Add-in is going to be used to insert a contact and create an interaction where custom fields are exposed ("Mail From", "Mail To", Mail Received On", etc.) and where procedure is going to automatically populate custom fields from fields of the email message ("From:", "To:", "Subject", "Sent") and the body text of the email message is going to be imported in the field "Comments" (blob datatype).
Could you please point me in the right direction on extending the Contacts Insights (BC Outlook Add-in) for BC SaaS?
I have extended standard tables (interaction log entry, segment line, etc.) and displayed those fields on required pages, and created/extended procedures to populate the data. Everything works as expected, except my knowledge is limited regarding the extension of BC Outlook Add-in.
And I need to insert the email body text to the comments field, that is of type Blob (using Azure Blob Storage) - I think I can use here InStream, OutStreams, right?
Also the signature part would be nice to include in some custom fields of the interaction.
and the visual representation of the issue:

Thank you
BR Damjan
How to populate custom fields displayed on Page - "Create Interaction" with standard fields from Outlook e-mail message?
I cannot figure out how to map field ("Subject", "From", "Sent") of the email message to custom field ("Mail From", "Mail To", Mail Received On", etc.).
Business Case: As email message is received, Sales Manager reads the received email message and creates an interaction, where the process should be automatized as much as possible.
Solution: BC Outlook Add-in is going to be used to insert a contact and create an interaction where custom fields are exposed ("Mail From", "Mail To", Mail Received On", etc.) and where procedure is going to automatically populate custom fields from fields of the email message ("From:", "To:", "Subject", "Sent") and the body text of the email message is going to be imported in the field "Comments" (blob datatype).
Could you please point me in the right direction on extending the Contacts Insights (BC Outlook Add-in) for BC SaaS?
I have extended standard tables (interaction log entry, segment line, etc.) and displayed those fields on required pages, and created/extended procedures to populate the data. Everything works as expected, except my knowledge is limited regarding the extension of BC Outlook Add-in.
And I need to insert the email body text to the comments field, that is of type Blob (using Azure Blob Storage) - I think I can use here InStream, OutStreams, right?
Also the signature part would be nice to include in some custom fields of the interaction.
and the visual representation of the issue:

Thank you
BR Damjan
0
Best Answer
-
Just to update on this thread.
I managed to get all data from email message in the custom procedure inserted in OnInitializeContext in CU: "Office Host Management", and I also created a custom table (copy of T1600 - "Office Add-In Context" where I added some additional fields and record is being copied from base T1600 to this new table, and data are being mapped from that new custom table to the T5077 as user is creating the interaction.
Thanks Damjan0
Answers
-
Just to update on this thread.
I managed to get all data from email message in the custom procedure inserted in OnInitializeContext in CU: "Office Host Management", and I also created a custom table (copy of T1600 - "Office Add-In Context" where I added some additional fields and record is being copied from base T1600 to this new table, and data are being mapped from that new custom table to the T5077 as user is creating the interaction.
Thanks Damjan0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions