Hi everyone ... I've always thought it impossible to push data from a full sandbox.  Am I wrong?  Are there any tools out there?  Thanks!

I have a formula field where I need to return varying values based upon an opportunity with or without a related campaign.  IF my opporunity has NO campaigns, I need to use this forumla.  

Scenario ONE has no syntax errors:

IF(CampaignId  = null &&  CustomField__c <> null, "Value 1", "Value 2")

If my opportunity has a campaign, I need to add this logic:

Scenario TWO has no syntax errors:

CASE(
Campaign.Type,
"Direct Mail","Direct Mail",
"Email","Email",
"Trade Show","Trade Show",
""
)

I'm trying
 

CASE(
CampaignId  = null &&  CustomField__c <> null, "Value 1", "Value 2"),
Campaign.Type,
"Direct Mail","Direct Mail",
"Email","Email",
"Trade Show","Trade Show",
""
)
)

Error: Syntax error. Extra ','

Hi ... We have customers who send documents for review using email-to-case.  The documents come as email attachments which land on the case - attachment related list.  We would like to send an automated email referencing the attached document using workflow rules.  The workflow rule works with the exception of including the document in the reply.  Here's what I'm using for my VF page, but it's not pulling the attachments

<messaging:emailTemplate subject="Testing Attachment Lists" recipientType="Contact" relatedToType="Case">
<messaging:plainTextEmailBody >
Thank you for your email regarding the attached document(s).  We will review your document and reply shortly.  
<apex:relatedList list="Attachments" />
</messaging:plainTextEmailBody>
</messaging:emailTemplate>

I have a formula field where I need to return varying values based upon an opportunity with or without a related campaign.  IF my opporunity has NO campaigns, I need to use this forumla.  

Scenario ONE has no syntax errors:

IF(CampaignId  = null &&  CustomField__c <> null, "Value 1", "Value 2")

If my opportunity has a campaign, I need to add this logic:

Scenario TWO has no syntax errors:

CASE(
Campaign.Type,
"Direct Mail","Direct Mail",
"Email","Email",
"Trade Show","Trade Show",
""
)

I'm trying
 

CASE(
CampaignId  = null &&  CustomField__c <> null, "Value 1", "Value 2"),
Campaign.Type,
"Direct Mail","Direct Mail",
"Email","Email",
"Trade Show","Trade Show",
""
)
)

Error: Syntax error. Extra ','