I know that SLX creates a unique opportunity ID, and I want to put that on a template.

How can I create a field in a template (word-letter template) that will pull the correct number out?

I tried to use the "insert special field">SQL>Text then when I am in the field editor, I click on the SQL line (the second one) and choose Opportunity ID, but then when I close it says "There are one or more Saleslogix SQL fields where something other than a SELECT statement has been used."

 We are running SLX 7.5.1 

Hi Michael,

If your using the SQL field editor you will need to use something like:

Select Opportunityid from Opportunity Where Opportunityid = :OpportunityID

I hope this helps, let me know how you get on.

Regards, Adam Travers