You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Extract the 'sent to' email address in the header, not the 'delivered to'

Received Response
9
Views
2
Comments
edited May 25, 2021 3:41PM in Reporting & Analytics for B2C Service 2 comments

Summary

We need to know what email address our customers are utilizing, we have dozen of them.

Content

We have dozen email address our customers can use. We need to understand which ones they are using in a report.  Using the BUI, we can look at the Email Header and see this, I cannot duplicate this extract.

the code I found in the forum, is pulling in the 'delivered to' email address

 

Version

20A

Code Snippet

substr(to_char(threads.mail_hdr),0+instr(to_char(threads.mail_hdr),'To:'),-1+instr(to_char(threads.mail_hdr),'MIME')-instr(to_char(threads.mail_hdr),'To:'))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!