function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
karthikakarthika 

Can I get email of the user from opportunity

Hi,

 

I am new to Salesforce and can you please let me know can we query the opportunity and get the email address of the opportunity owner.

 

It is urgent, any help would be appreciated.

 

Thanks

 

sanjdevsanjdev

Hi ,

 

You can try the below SOQL Query. You can modify the where condition based on your requirement.

 

SELECT Email,Name
FROM User
WHERE Id IN (SELECT OwnerId
FROM Opportunity
WHERE Opportunity Name = 'Test')

 

Mark it as resolved if it helps you.

Sanj
Vamsi Krishna 610Vamsi Krishna 610
Hi,
you can use this query to get owner email address.

SELECT Id, Owner.Email from opportunity

Mark it as resolved if it helps you.