• SFDCAdmin73
  • NEWBIE
  • 65 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 17
    Questions
  • 17
    Replies
Hi Guys,

I am not sure if this possible but I am going to ask any way.  I have an opportunity with product report. The report is filtered to display opportunities for a specific opportunity record type and opportunities with Stage = 'Closed Won'.

On this report, I created a Win Ratio report formula. See formula below. In the report formula I am dividing by the total # of opportunities (Account.Total_Opps__c:SUM). However I need to divid by the total # of opportunities by OEM and not Account. OEM is picklist field that appears on the opportunity record.  Is it possible for figure out the Total # of Opportunities by OEM for the current quarter regardless of Opportunity status?

IF(WON:SUM=0,0,WON:SUM/Account.Total_Opps__c:SUM)

User-added image

I appreciate the help!

 
I have field on the opporutnity that gives the $ amount of the opportunity for the current fiscal quarter. The reason is for this is because we have opportunities that are on-going over the course of several quarters.  However not every deal is a 'on-going' opportunity. Therefore on the report the 'Total Amount for Current FQ' field displays $0.00 for some of the opportunities.

I want to create a custom formula in the report that will display the value of the 'Total Amount for Current FQ' field and if the value = $0.00, then display the Amount value instead. 

How would I write this formula?
  • Total_Amount_for_Current_FQ__c:SUM
  • AMOUNT:SUM
I appreciate the help!

 
I created a VF email template. When the email template is sent through a workflow, I need the attachments on the opportunity record to be attached to the email. Therefore I added the following code on lines 2-4.

I am recieving trhe following error:  Error occurred trying to load the template for preview: Subscript is invalid because list is empty. Please try editing your markup to correct the problem.

I am not sure how to resolve it. I appreciate any help! Thanks in advance. 
 
<messaging:emailTemplate subject="OEM Cost Relief (Rebate) Submitted" recipientType="User" relatedToType="OEM_Rebate_Claims__c">
<messaging:attachment filename="{!relatedTo.Attachments[0].Name}" renderAs="{!relatedTo.Attachments[0].ContentType}">
 <apex:repeat var="cx" value="{!relatedTo.Attachments}">
</apex:repeat>
</messaging:attachment>
<messaging:htmlEmailBody >        
    <html>
        <body>
        <p>Dear Ram Sridhar,</p>   
        <p> The following OEM Cost Relief (Rebate) has been submitted for your review. The rebate claim details are listed below. Attached to this email is proof of delivery.</p>        

       <STYLE type="text/css">
               TH {font-size: 14px; border:solid #CCCCCC; font-face: arial;background: #0080ff; border-width: 1; color:#ffffff; text-align: center } 
               TD  {font-size: 14px; border:solid #CCCCCC; border-width: 1; font-face: ariel; text-align: center } 
               TABLE {border: solid #CCCCCC; border-width: 1}
               TR {border: solid #CCCCCC; border-width: 1}
         </STYLE>
           <font face="ariel" size="3">
    <table>
    <tr> 
    <th>Ship Date</th><th>Invoice #</th><th>OEM</th><th>OEM Order#</th><th>QLogic Model #</th><th>Quantity Claimed</th><th>Customer Name</th><th>Customer Address</th><th>QLogic SFDC #</th><th>Claim Value Per Unit</th><th>Total Value Claimed</th></tr>
       <tr>
           <td><apex:outputText value="{0, date, MMMM d','yyyy}"><apex:param value="{!relatedTo.Ship_Date__c}" /></apex:outputText></td>
           <td>{!relatedTo.Invoice__c}</td>
           <td>{!relatedTo.OEM_Opportunity__r.OEM__c}</td>
           <td>{!relatedTo.OEM_Order__c}</td>
           <td>{!relatedTo.Product__r.Name}</td>
           <td><apex:outputText value="{0, number, #,###.00}"> <apex:param value="{!relatedTo.Quantity_Claimed__c}" /></apex:outputText></td>
           <td>{!relatedTo.Customer_Name__c}</td>
           <td>{!relatedTo.OEM_Opportunity__r.Account.Site_State_Province__c},{!relatedTo.OEM_Opportunity__r.Account.Site_Zip_Postal_Code__c},{!relatedTo.OEM_Opportunity__r.Account.Site_Country__c}</td>
           <td>{!relatedTo.QLogic_SFDC__c}</td>
           <td><apex:outputText value="{0, number, $#,###.00}"> <apex:param value="{!relatedTo.Claim_Value_Per_Unit__c}" /></apex:outputText></td>
           <td><apex:outputText value="{0, number, $#,###.00}"> <apex:param value="{!relatedTo.Total_Value_Claimed__c}" /></apex:outputText></td>
       </tr>                 
       </table> 
       
      <p>If you have any questions regarding this claims please contact {!relatedTo.OEM_Rebate_Manager__c}.</p>
      <p>Regards</p>
      <p> OEM Rebate Claim System Manager </p>
    </font>     
 </body>
  </html>
   </messaging:htmlEmailBody> 
</messaging:emailTemplate>

 
I created a VF email template. When the email template is sent through a workflow, I need the attachments on the opportunity record to be attached to the email. Therefore I added the following code on lines 2-4.

I am recieving trhe following error:  Error occurred trying to load the template for preview: Subscript is invalid because list is empty. Please try editing your markup to correct the problem.

I am not sure how to resolve it. I appreciate any help! Thanks in advance. 
<messaging:emailTemplate subject="OEM Cost Relief (Rebate) Submitted" recipientType="User" relatedToType="OEM_Rebate_Claims__c">
<messaging:attachment filename="{!relatedTo.Attachments[0].Name}" renderAs="{!relatedTo.Attachments[0].ContentType}">
 <apex:repeat var="cx" value="{!relatedTo.Attachments}">
</apex:repeat>
</messaging:attachment>
<messaging:htmlEmailBody >        
    <html>
        <body>
        <p>Dear Ram Sridhar,</p>   
        <p> The following OEM Cost Relief (Rebate) has been submitted for your review. The rebate claim details are listed below. Attached to this email is proof of delivery.</p>        

       <STYLE type="text/css">
               TH {font-size: 14px; border:solid #CCCCCC; font-face: arial;background: #0080ff; border-width: 1; color:#ffffff; text-align: center } 
               TD  {font-size: 14px; border:solid #CCCCCC; border-width: 1; font-face: ariel; text-align: center } 
               TABLE {border: solid #CCCCCC; border-width: 1}
               TR {border: solid #CCCCCC; border-width: 1}
         </STYLE>
           <font face="ariel" size="3">
    <table>
    <tr> 
    <th>Ship Date</th><th>Invoice #</th><th>OEM</th><th>OEM Order#</th><th>QLogic Model #</th><th>Quantity Claimed</th><th>Customer Name</th><th>Customer Address</th><th>QLogic SFDC #</th><th>Claim Value Per Unit</th><th>Total Value Claimed</th></tr>
       <tr>
           <td><apex:outputText value="{0, date, MMMM d','yyyy}"><apex:param value="{!relatedTo.Ship_Date__c}" /></apex:outputText></td>
           <td>{!relatedTo.Invoice__c}</td>
           <td>{!relatedTo.OEM_Opportunity__r.OEM__c}</td>
           <td>{!relatedTo.OEM_Order__c}</td>
           <td>{!relatedTo.Product__r.Name}</td>
           <td><apex:outputText value="{0, number, #,###.00}"> <apex:param value="{!relatedTo.Quantity_Claimed__c}" /></apex:outputText></td>
           <td>{!relatedTo.Customer_Name__c}</td>
           <td>{!relatedTo.OEM_Opportunity__r.Account.Site_State_Province__c},{!relatedTo.OEM_Opportunity__r.Account.Site_Zip_Postal_Code__c},{!relatedTo.OEM_Opportunity__r.Account.Site_Country__c}</td>
           <td>{!relatedTo.QLogic_SFDC__c}</td>
           <td><apex:outputText value="{0, number, $#,###.00}"> <apex:param value="{!relatedTo.Claim_Value_Per_Unit__c}" /></apex:outputText></td>
           <td><apex:outputText value="{0, number, $#,###.00}"> <apex:param value="{!relatedTo.Total_Value_Claimed__c}" /></apex:outputText></td>
       </tr>                 
       </table> 
       
      <p>If you have any questions regarding this claims please contact {!relatedTo.OEM_Rebate_Manager__c}.</p>
      <p>Regards</p>
      <p> OEM Rebate Claim System Manager </p>
    </font>     
 </body>
  </html>
   </messaging:htmlEmailBody> 
</messaging:emailTemplate>




 
I created a simple Apex Class but now I need to create an Apex Test Method for code coverage. I am not sure how to write this?

Here is the Apex Class. Below that I have a Test Class but it is not correct. Can someone help with this? I appreciate it!
trigger SetTaskTypeToEmail on Task (before insert) {
    for (Task nc : Trigger.new) {
        String subject = nc.Subject;
        String description = nc.Description;
        if (
                subject != null &&
                subject.startsWith('Email:') &&
                description != null &&
                description.startsWith('Additional To:')
        ) {
            nc.Type = 'Email';
        }
    }
}

Apex Test Method I wrote but it's not correct. Need help!
 
isTest
private class TestSetTaskTypeToEmail {
  public static testMethod void testTTrigger(){
        
List<task> t = new List<task>{ new task(
		 if (
                subject != null &&
                subject.startsWith('Email:') &&
                description != null &&
                description.startsWith('Additional To:')
        ) {
            nc.Type = 'Email';
        insert t;  
 }
}

Thanks!
The following errors were encountered while processing an incoming email:
 
CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY : SetTaskTypeToEmail: execution of BeforeInsert
 
caused by: System.NullPointerException: Attempt to de-reference a null object
 
Trigger.SetTaskTypeToEmail: line 6, column 1

I am not sure how to resolve this issue. It is a simple trigger. Please see code below. I appreciate any help. Thanks!
 
trigger SetTaskTypeToEmail on Task (before insert) {
For (Task nc:Trigger.new) {
String subject = nc.Subject;
String description = nc.Description;
If( subject != null && subject.startsWith('Email:') && description.startsWith('Additional To:')) {
nc.Type = 'Email';
}
}
}

 
I created a visualforce PDF page on the opportunity object. I am trying to create a hyperlink formual field to this VF page. This field will be used in opportunity reports. 

However when I click on the link, I recieve the following error:

This site can’t be reached
apex’s server DNS address could not be found.
DNS_PROBE_FINISHED_NXDOMAIN


Here is the formula that I have: HYPERLINK("https://apex/WinLossOpportunityReportPDF?Id="+ Id,"Win/Loss Opportunity Report","_parent")

User-added image
What am I doing wrong? I appreciate any help!

Thanks!
 
The parsing failed when I tried to generate an Apex Class from WSDL file. 
 
This is the error that I received - External schema import not supported.
 
Based on what I am reading in the forum, I need to do the following:
 
1. Inside <wsdl:types> (below the last <schema>) paste each referenced .xsd file content. Paste only <schema></schema>
2. Once all schemas are in the WSDL then comment all <xsd:import> using <!-- -->. They are no longer needed.
3. Please save changes and send back to me.

I am not the one who created the XML file and not sure how to update it with the instructions listed above? I apreciate any help!

Thanks!
 
<?xml version="1.0" encoding="UTF-8" ?>
<wsdl:definitions
     name="SerialInquiry"
     targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/http/QLogicConsolidatedApplication/QLSerialInquiryService/SerialInquiry"
     xmlns:tns="http://xmlns.oracle.com/pcbpel/adapter/http/QLogicConsolidatedApplication/QLSerialInquiryService/SerialInquiry"
     xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"
     xmlns:msg_in_out="http://www.qlogic.com/soaintegrations/Oracle/xsd/QLSerialInquiryServiceSchema"
     xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
     xmlns:plt="http://schemas.xmlsoap.org/ws/2003/05/partner-link/"
    >
    <wsdl:documentation>
        <abstractWSDL>https://fmwtest.qlc.com:8080/soa-infra/services/default/QLSerialInquiryService!1.0/SerialInquiry.wsdl</abstractWSDL>
    </wsdl:documentation>
    <plt:partnerLinkType name="Request_Response_plt">
        <plt:role name="Request-Response_role">
            <plt:portType name="tns:Request_Response_ptt"/>
        </plt:role>
    </plt:partnerLinkType>
    <wsdl:types>
        <schema xmlns="http://www.w3.org/2001/XMLSchema">
            <import namespace="http://www.qlogic.com/soaintegrations/Oracle/xsd/QLSerialInquiryServiceSchema"
                 schemaLocation="https://fmwtest.qlc.com:8080/soa-infra/services/default/QLSerialInquiryService/SerialInquiry?XSD=xsd/QLSerialInquiryServiceSchema.xsd"/>
        </schema>
    </wsdl:types>
    <wsdl:message name="SerialInquiryRequest_msg_in">
        <wsdl:part name="SerialInquiryRequest" element="msg_in_out:SerialInquiryRequest"/>
    </wsdl:message>
    <wsdl:message name="SerialInquiryResponse_msg_out">
        <wsdl:part name="SerialInquiryResponse" element="msg_in_out:SerialInquiryResponse"/>
    </wsdl:message>
    <wsdl:portType name="Request_Response_ptt">
        <wsdl:operation name="Request-Response">
            <wsdl:input message="tns:SerialInquiryRequest_msg_in"/>
            <wsdl:output message="tns:SerialInquiryResponse_msg_out"/>
        </wsdl:operation>
    </wsdl:portType>
    <wsdl:binding name="Request_Response_pttBinding" type="tns:Request_Response_ptt">
        <soap:binding transport="http://schemas.xmlsoap.org/soap/http"/>
        <wsdl:operation name="Request-Response">
            <soap:operation style="document" soapAction="Request-Response"/>
            <wsdl:input>
                <soap:body use="literal"/>
            </wsdl:input>
            <wsdl:output>
                <soap:body use="literal"/>
            </wsdl:output>
        </wsdl:operation>
    </wsdl:binding>
    <wsdl:binding name="Request_Response_ptHttpPOST" type="tns:Request_Response_ptt">
        <http:binding xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" verb="POST"/>
        <wsdl:operation name="Request-Response">
            <http:operation xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" location=""/>
            <wsdl:input>
                <mime:content xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" type="text/xml"/>
            </wsdl:input>
            <wsdl:output>
                <mime:content xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" type="text/xml"/>
            </wsdl:output>
        </wsdl:operation>
    </wsdl:binding>
    <wsdl:service name="SerialInquiry">
        <wsdl:port name="Request_Response_pt" binding="tns:Request_Response_ptHttpPOST">
            <http:address xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" location="https://fmwtest.qlc.com:8080/soa-infra/services/default/QLSerialInquiryService/SerialInquiry"/>
        </wsdl:port>
        <wsdl:port name="Request_Response_pt_soappt" binding="tns:Request_Response_pttBinding">
            <soap:address location="https://fmwtest.qlc.com:8080/soa-infra/services/default/QLSerialInquiryService/SerialInquiry"/>
        </wsdl:port>
    </wsdl:service>
</wsdl:definitions>

 
I am not strong in writing Apex Classes and Trigger and need assitance.

I am receiving the following error: Method does not exist or incorrect signature: populateRollUpFieldsOnOpportunity(newRecordsMap);

Here is the section of code for your reference. The error is on line 25. 
public with sharing class MultipleShipmentTrackingTriggerHandler {    
    public static set<Id> opptyIds = new set<Id>(); 
    public static boolean oliUpdateRunning = false;
    public static boolean doNotUpdateQuantity = false;
    public static boolean doNotUpdateAmount = false;
    
    public static void beforeInsertHandler(List<Multiple_Shipment_Tracking__c> newRecords){
        // validate the product , it must be from oppotunity line items
        validateProduct(newRecords);
        
        // populate fields on multiple shipment tracking record based on the valid product selected
        prePopulateFields(newRecords, false, null);     
    }
    
    public static void beforeUpdateHandler(Map<Id,Multiple_Shipment_Tracking__c> oldRecordsMap, Map<Id,Multiple_Shipment_Tracking__c> newRecordsMap){
        // validate the product , it must be from oppotunity line items
        validateProduct(newRecordsMap.values());            
        
        // populate fields on  multiple shipment tracking record based on the valid product selected
        prePopulateFields(newRecordsMap.values(), false, oldRecordsMap);
    }
    
    public static void afterInsertHandler(Map<Id,Multiple_Shipment_Tracking__c> newRecordsMap){
        // populate roll up calculation fields on opportunity
        populateRollUpFieldsOnOpportunity(newRecordsMap);
    }
    
    public static void afterUpdateHandler(Map<Id,Multiple_Shipment_Tracking__c> oldRecordsMap, Map<Id,Multiple_Shipment_Tracking__c> newRecordsMap){
        // populate roll up calculation fields on opportunity
        populateRollUpFieldsOnOpportunity(newRecordsMap);

 
We have a custom signup form our support site. On the form we have a country and states picklist. When the user selects United States as a value for Country field, no values are appearing on the States List. See image below and VF page code. I am not sure why values for the State list are not appearing.

User-added image
VF page code section referencing Country and State list:
<apex:outputLabel styleClass="regLabel" value="Country" for="country"><font color="red" >*</font></apex:outputLabel>
           <apex:selectList value="{!country}" size="1" id="countryList" required="true" onchange="renderStateAS(this.value)" style="width:150px;">
             <apex:selectOptions value="{!countries}"/>
           </apex:selectList>
           <apex:outputLabel styleClass="regLabel" value="State/Province" for="stateProvince" />
           <apex:selectList value="{!stateProvince}" size="1" id="StateList" >
             <apex:selectOptions value="{!states}"/>
           </apex:selectList>
           
           
           <apex:outputText value=""/>  
           <apex:outputText value=""/>
           <apex:outputText value=""/>
           <apex:commandButton action="{!registerUser}" value="Create Account" id="submit" styleClass="submitButton"/>
         </apex:panelGrid> 
       
       <apex:actionFunction name="renderStateAS" action="{!renderState}" reRender="StateList" immediate="true">
         <apex:param name="CountryParam" value="" assignTo="{!country}" />
       </apex:actionFunction>
    </apex:form>
    </apex:outputPanel>
     </center>
      <script>
        function populateUserName(compVal){
            $("[id$=userName]").val(compVal);
            if(compVal != null && compVal.length > 0)
                var compValSplit = compVal.split('@');
                $("[id$=communityNickname]").val(compValSplit[0]);
        }
      </script>
      </div>
    </apex:define>
</apex:composition>
</apex:page>

 
I am a creating a custom VF page that renders as a PDF for the Opportunity object. See image below. I need to diplay the actiivty history related list on the opportunity in the VF page as a html table. Not sure how to do this. See image below. I appreciate the help!

User-added image
 
<apex:page standardController="Opportunity"  renderAS="pdf"> 
<html> 
   <head>
      <style>
        @page {size: A4 landscape; /* ISO/JIS A4 (210mm x 297mm) */  
                     margin: 5mm; 
                  } 
            @page:first {  
                     size: A4 landscape; /* ISO/JIS A4 (210mm x 297mm) */ 
                     margin: 5mm; 
                     margin-top: 3mm; 
    </style>                 
    </head>  
  </html>   
  
<apex:pageBlock title="{!Opportunity.name} Opportunity Dashboard {!Opportunity.LastModifiedDate}">
<TABLE BORDER="2" WIDTH="100%" style="border: solid gray;">
   <TR>
      <TD style="background-color:#dadae2; width:12%"><center><b>Coverage</b></center></TD>
      <TD><b>Sales:</b>{!Opportunity.Sales__c}</TD>
      <TD><b>SE:</b>{!Opportunity.SE__c}</TD>
      <TD><b>BU:</b>{!Opportunity.BU__c}</TD>
   </TR>
</TABLE>
<TABLE border="0" cellspacing="0" cellpadding="0" width= "100%">
<TR>
<TD WIDTH="33%"> 
<TABLE BORDER="2" WIDTH="100%" style="border: solid gray;">
   <TR>
      <TD style="background-color:#dadae2"><center><b>Opportunity Sizing</b></center></TD>
   </TR>
</TABLE>
<TABLE BORDER="2" WIDTH="100%" style="border: solid gray;">
   <TR>
      <TD><b>Deal Amount:</b>{!Opportunity.Actual_Amount__c}</TD>
   </TR>
</TABLE>
<TABLE BORDER="2" WIDTH="100%" style="border: solid gray;">
   <TR> 
      <TD><b>Q1:</b>{!Opportunity.Total_Amount_Q1__c}</TD>
      <TD><b>Q2:</b>{!Opportunity.Total_Amount_Q2__c}</TD>
      <TD><b>Q3:</b>{!Opportunity.Total_Amount_Q3__c}</TD>
      <TD><b>Q4:</b>{!Opportunity.Total_Amount_Q2__c}</TD>
   </TR>
</TABLE>
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">
   <TR>
      <TD style="background-color:#dadae2"><center><b>Decision Milestones</b></center></TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">
   <TR>    
      <TD style="background-color:#b5eaba;"><center><b>Event</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>Dates</b></center></TD>
   </TR>
   <TR>   
      <TD width="65%"><b>Evaluation Start and End Date:</b></TD>
      <TD><apex:outputText value="{0, date, MMMM d','yyyy}"><apex:param value="{!Opportunity.Evaluation_Start_Date__c}"/></apex:outputText>
-<apex:outputText value="{0, date, MMMM d','yyyy}"><apex:param value="{!Opportunity.Evaluation_End_Date__c}"/></apex:outputText></TD>
   <TR>  
     <TD><b>Evaluation DeBrief</b></TD>
     <TD>{!Opportunity.Evaluation_DeBrief__c}</TD>
   </TR>
   <TR>  
     <TD><b>Internal Selection Mtg</b></TD>
     <TD>{!Opportunity.Internal_Selection_Mtg__c}</TD>
   </TR>
   <TR>  
     <TD><b>Notification of Intent</b></TD>
     <TD>{!Opportunity.Notification_of_Intent__c}</TD>
   </TR>
   <TR>  
     <TD><b>Buying Vehicle Identified</b></TD>
     <TD>{!Opportunity.Buying_Vehicle_Identified__c}</TD>
   </TR>
    <TR>  
     <TD><b>Negotiation Start and End Date</b></TD>
     <TD><apex:outputText value="{0, date, MMMM d','yyyy}"><apex:param value="{!Opportunity.Negotiation_Start_Date__c}"/></apex:outputText>
-<apex:outputText value="{0, date, MMMM d','yyyy}"><apex:param value="{!Opportunity.Negotiation_End_Date__c}"/></apex:outputText></TD>
   </TR>
   <TR>  
     <TD><b>Contract Execution</b></TD>
     <TD>{!Opportunity.Contract_Execution__c}</TD>
   </TR>
   <TR>  
     <TD><b>First Forecast Meeting</b></TD>
     <TD>{!Opportunity.First_Forecast_Meeting__c}</TD>
   </TR>
   <TR>  
     <TD><b>Pre-Production Order</b></TD>
     <TD>{!Opportunity.Pre_Production_Order__c}</TD>
   </TR>
   <TR>  
     <TD><b>Pre-Production Delivery</b></TD>
     <TD>{!Opportunity.Pre_Production_Delivery__c}</TD>
  </TR> 
 </TR>
 <TR>  
     <TD><b>1St Production Order</b></TD>
     <TD>{!Opportunity.X1st_Production_Order__c}</TD>
  </TR> 
  <TR>  
     <TD><b>1St Production Delivery</b></TD>
     <TD>{!Opportunity.X1st_Production_Delivery__c}</TD>
  </TR>   
</TABLE>
<TD width="33%">
<TABLE BORDER="2" WIDTH="100%"  style="border: solid gray;">
   <TR>
      <TD style="background-color:#dadae2"><center><b>Decision Criteria Positioning (1/L =>5/H)</b></center></TD>
   </TR>
</TABLE>
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">
   <TR>    
      <TD width="60%" style="background-color:#b5eaba;"><center><b>Criteria/Goal</b></center></TD>
      <TD width="20%" style="background-color:#b5eaba;"><center><b>QLogic</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>{!Opportunity.Competitor_1__c}</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>{!Opportunity.Competitor_2__c}</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>{!Opportunity.Competitor_3__c}</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>{!Opportunity.Competitor_4__c}</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>{!Opportunity.Competitor_5__c}</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>{!Opportunity.Competitor_6__c}</b></center></TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">   
   <TR>  
     <TD width="60%">{!Opportunity.Criteria_Goal_1__c}</TD>
     <TD width="20%">{!Opportunity.QLogic_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_6__c}</TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">   
   <TR>  
     <TD width="60%">{!Opportunity.Criteria_Goal_2__c}</TD>
     <TD width="20%">{!Opportunity.QLogic_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_6__c}</TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">   
   <TR>  
     <TD width="60%">{!Opportunity.Criteria_Goal_3__c}</TD>
     <TD width="20%">{!Opportunity.QLogic_Postioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_6__c}</TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">   
   <TR>  
     <TD width="60%">{!Opportunity.Criteria_Goal_4__c}</TD>
     <TD width="20%">{!Opportunity.QLogic_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_6__c}</TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">   
   <TR>  
     <TD width="60%">{!Opportunity.Criteria_Goal_5__c}</TD>
     <TD width="20%">{!Opportunity.QLogic_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_6__c}</TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">   
   <TR>  
     <TD width="60%">{!Opportunity.Criteria_Goal_6__c}</TD>
     <TD width="20%">{!Opportunity.QLogic_Postioning_6__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_6__c}</TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%"  style="border: solid gray;">
   <TR>
      <TD style="background-color:#dadae2"><center><b>Key Player Match-Up</b></center></TD>
   </TR>
</TABLE>
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">
   <TR>    
      <TD width="60%" style="background-color:#b5eaba;"><center><b>Customer Contact</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>Title</b></center></TD>
   </TR>
</TABLE> 
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">
 <TR>  
     <TD>Name:{!Opportunity.Customer_Contact_1__c}</TD>
     <TD>{!Opportunity.CustomerContact_Title_1__c}</TD>
   </TR>
   <TR>  
     <TD>Name:{!Opportunity.Customer_Contact_2__c}</TD>
     <TD>{!Opportunity.Customer_Contact_2__c}</TD>
   </TR>
   <TR>  
     <TD>Name:{!Opportunity.Customer_Contact_3__c}</TD>
     <TD>{!Opportunity.CustomerContact_Title_3__c}</TD>
   </TR>
</TABLE>
<TD width="33%">
</TD>
</TD>
</TD>
</TR>
</TABLE>
</apex:pageBlock>
</apex:page>

 
I need the following VF page to render as a PDF in a lanscape orientation. I am not sure what I missing because the code I applied is not working. See code below. 
User-added image
 
<apex:page standardController="Opportunity" renderAS="pdf"> 
    <head>
        <style>
        @page {  
                     size: A4 landscape; /* ISO/JIS A4 (210mm�297mm) */  
                     margin: 5mm; 
                  } 
            @page:first {  
                     size: A4 landscape; /* ISO/JIS A4 (210mm�297mm) */ 
                     margin: 5mm; 
                     margin-top: 3mm; 
      </style>
    </head>    
<apex:pageBlock title="{!Opportunity.name} Opportunity Dashboard {!Opportunity.LastModifiedDate}">
<TABLE BORDER="2" WIDTH="100%" style="border:2px solid grey;">
   <TR>
      <TD style="background-color:#dadae2; width:12%"><center><H4>Coverage</H4></center></TD>
      <TD><b>Sales:</b>{!Opportunity.Sales__c}</TD>
      <TD><b>SE:</b>{!Opportunity.SE__c}</TD>
      <TD><b>BU:</b>{!Opportunity.BU__c}</TD>
   </TR>
</TABLE>

<TABLE BORDER="2" WIDTH="50%" style="border:2px solid black;">
   <TR>
      <TD style="background-color:#dadae2"><center><H4>Opportunity Sizing</H4></center></TD>
   </TR>
</TABLE>
<TABLE BORDER="2" WIDTH="50%" style="border:2px solid black;">
   <TR>
      <TD><b>Deal Amount $:</b>{!Opportunity.Actual_Amount__c}</TD>
      <TD><b>Total Amount Q1:</b>{!Opportunity.Total_Amount_Q1__c}</TD>
   </TR>
</TABLE>
<TABLE BORDER="2" WIDTH="50%" style="border:2px solid black;">
   <TR>   
      <TD><b>Total Amount Q2:</b>{!Opportunity.Total_Amount_Q2__c}</TD>
      <TD><b>Total Amount Q3:</b>{!Opportunity.Total_Amount_Q3__c}</TD>
      <TD><b>Total Amount Q4:</b>{!Opportunity.Total_Amount_Q2__c}</TD>
   </TR>
</TABLE>

<apex:pageBlockSection title="Opportunity Sizing" columns="2"> <apex:outputField title="Amount" value="{!Opportunity.Amount}"/> </apex:pageBlockSection>

<apex:pageBlockSection title="On-Going Revenue Details" columns="2"> <apex:outputField title="Total Amount for Current FQ" value="{!Opportunity.Total_Amount_for_Current_FQ__c}"/>
<apex:outputField title="Total Amount Q1" value="{!Opportunity.Total_Amount_Q1__c}"/>
<apex:outputField title="Total Amount Q3" value="{!Opportunity.Total_Amount_Q3__c}"/>
<apex:outputField title="Total Amount Q2" value="{!Opportunity.Total_Amount_Q2__c}"/>
<apex:outputField title="Total Amount Q4" value="{!Opportunity.Total_Amount_Q4__c}"/>
</apex:pageBlockSection>

<apex:pageBlockSection title="Key Player Match-Up" columns="2"> <apex:outputField title="Customer Contact" value="{!Opportunity.Customer_Contact_1__c}"/>
<apex:outputField title="Title" value="{!Opportunity.CustomerContact_Title_1__c}"/>
<apex:outputField title="Customer Contact" value="{!Opportunity.Customer_Contact_2__c}"/>
<apex:outputField title="Title" value="{!Opportunity.CustomerContact_Title_2__c}"/>
<apex:outputField title="Customer Contact" value="{!Opportunity.Customer_Contact_3__c}"/>
<apex:outputField title="Title" value="{!Opportunity.CustomerContact_Title_3__c}"/>
</apex:pageBlockSection>

<apex:pageBlockSection title="Decision Milestones" columns="2"> <apex:outputField title="Evaluation Start Date" value="{!Opportunity.Evaluation_Start_Date__c}"/>
<apex:outputField title="Negotiation Start Date" value="{!Opportunity.Negotiation_Start_Date__c}"/>
<apex:outputField title="Evaluation End Date" value="{!Opportunity.Evaluation_End_Date__c}"/>
<apex:outputField title="Evaluation DeBrief" value="{!Opportunity.Evaluation_DeBrief__c}"/>
<apex:outputField title="Negotiation End Date" value="{!Opportunity.Negotiation_End_Date__c}"/>
<apex:outputField title="Pre-Production Order" value="{!Opportunity.Pre_Production_Order__c}"/>
<apex:outputField title="1st Production Order" value="{!Opportunity.X1st_Production_Order__c}"/>
<apex:outputField title="Pre-Production Delivery" value="{!Opportunity.Pre_Production_Delivery__c}"/>
<apex:outputField title="1st Production Delivery" value="{!Opportunity.X1st_Production_Delivery__c}"/>
<apex:outputField title="Internal Selection Mtg" value="{!Opportunity.Internal_Selection_Mtg__c}"/>
<apex:outputField title="Buying Vehicle Identified" value="{!Opportunity.Buying_Vehicle_Identified__c}"/>
<apex:outputField title="Notification of Intent" value="{!Opportunity.Notification_of_Intent__c}"/>
<apex:outputField title="Contract Execution" value="{!Opportunity.Contract_Execution__c}"/>
<apex:outputField title="First Forecast Meeting" value="{!Opportunity.First_Forecast_Meeting__c}"/>
</apex:pageBlockSection>

<apex:pageBlockSection title="Decision Criteria/ Positioning (1/L =>5/H)" columns="2"> <apex:outputField title="Criteria/Goal # 1:" value="{!Opportunity.Criteria_Goal_1__c}"/>
<apex:outputField title="QLogic Positioning # 1:" value="{!Opportunity.QLogic_Positioning_1__c}"/>
<apex:outputField title="Competitor #1:" value="{!Opportunity.Competitor_1__c}"/>
<apex:outputField title="Competitor Positioning # 1:" value="{!Opportunity.Competitor_Positioning_1__c}"/>
<apex:outputField title="Criteria/Goal #2:" value="{!Opportunity.Criteria_Goal_2__c}"/>
<apex:outputField title="QLogic Positioning # 2:" value="{!Opportunity.QLogic_Positioning_2__c}"/>
<apex:outputField title="Competitor #2:" value="{!Opportunity.Competitor_2__c}"/>
<apex:outputField title="Competitor Positioning # 2:" value="{!Opportunity.Competitor_Positioning_2__c}"/>
<apex:outputField title="Criteria/Goal # 3:" value="{!Opportunity.Criteria_Goal_3__c}"/>
<apex:outputField title="QLogic Postioning # 3:" value="{!Opportunity.QLogic_Postioning_3__c}"/>
<apex:outputField title="Competitor #3:" value="{!Opportunity.Competitor_3__c}"/>
<apex:outputField title="Competitor Positioning # 3:" value="{!Opportunity.Competitor_Positioning_3__c}"/>
<apex:outputField title="Criteria/Goal # 4:" value="{!Opportunity.Criteria_Goal_4__c}"/>
<apex:outputField title="QLogic Positioning # 4:" value="{!Opportunity.QLogic_Positioning_4__c}"/>
<apex:outputField title="Competitor #4:" value="{!Opportunity.Competitor_4__c}"/>
<apex:outputField title="Competitor Positioning # 4:" value="{!Opportunity.Competitor_Positioning_4__c}"/>
<apex:outputField title="Criteria/Goal # 5:" value="{!Opportunity.Criteria_Goal_5__c}"/>
<apex:outputField title="Competitor Positioning # 5:" value="{!Opportunity.Competitor_Positioning_5__c}"/>
<apex:outputField title="Competitor #5:" value="{!Opportunity.Competitor_5__c}"/>
<apex:outputField title="QLogic Positioning # 5:" value="{!Opportunity.QLogic_Positioning_5__c}"/>
<apex:outputField title="Criteria/Goal # 6:" value="{!Opportunity.Criteria_Goal_6__c}"/>
<apex:outputField title="Competitor Positioning # 6:" value="{!Opportunity.Competitor_Positioning_6__c}"/>
<apex:outputField title="Competitor #6:" value="{!Opportunity.Competitor_6__c}"/>
<apex:outputField title="QLogic Positioning # 6:" value="{!Opportunity.QLogic_Postioning_6__c}"/>
</apex:pageBlockSection>

<apex:pageBlockSection title="Special Pricing Request Required Information" columns="2"> <apex:outputField title="Primary Reason for SPR" value="{!Opportunity.Primary_Reason_for_SPR__c}"/>
<apex:outputField title="Ship Date From:" value="{!Opportunity.Ship_Date_From__c}"/>
<apex:outputField title="SPR Business Case Justification" value="{!Opportunity.Justification_Detail__c}"/>
<apex:outputField title="Ship Date To:" value="{!Opportunity.Ship_Date_To__c}"/>
<apex:outputField title="Approval Submission TimeStamp" value="{!Opportunity.Approval_Submission_TimeStamp__c}"/>
<apex:outputField title="Approval Complete TimeStamp" value="{!Opportunity.Approval_Complete_TimeStamp__c}"/>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:page>

Thanks!
Beth
I create a VF page that renders as a PDF. How do I put the information in a table format?

User-added image

Here is the code that I have for the VF page:
<apex:page standardController="Opportunity" renderAS="pdf"> 

<apex:sectionHeader title="Opportunity Dashboard"/> 
<apex:pageBlock title="{!Opportunity.name}{!Opportunity.LastModifiedDate}">

<apex:pageBlockSection title="Coverage" columns="3"> 
<apex:outputField title="Sales:" value="{!Opportunity.Sales__c}"/>
<apex:outputField title="SE:" value="{!Opportunity.SE__c}"/>
<apex:outputField title="BU:" value="{!Opportunity.BU__c}"/>
</apex:pageBlockSection>

<apex:pageBlockSection title="Key Player Match-Up" columns="2"> <apex:outputField title="Customer Contact" value="{!Opportunity.Customer_Contact_1__c}"/>
<apex:outputField title="Title" value="{!Opportunity.CustomerContact_Title_1__c}"/>
<apex:outputField title="Customer Contact" value="{!Opportunity.Customer_Contact_2__c}"/>
<apex:outputField title="Title" value="{!Opportunity.CustomerContact_Title_2__c}"/>
<apex:outputField title="Customer Contact" value="{!Opportunity.Customer_Contact_3__c}"/>
<apex:outputField title="Title" value="{!Opportunity.CustomerContact_Title_3__c}"/>
</apex:pageBlockSection>

<apex:pageBlockSection title="Decision Milestones" columns="2"> <apex:outputField title="Evaluation Start Date" value="{!Opportunity.Evaluation_Start_Date__c}"/>
<apex:outputField title="Negotiation Start Date" value="{!Opportunity.Negotiation_Start_Date__c}"/>
<apex:outputField title="Evaluation End Date" value="{!Opportunity.Evaluation_End_Date__c}"/>
<apex:outputField title="Evaluation DeBrief" value="{!Opportunity.Evaluation_DeBrief__c}"/>
<apex:outputField title="Negotiation End Date" value="{!Opportunity.Negotiation_End_Date__c}"/>
<apex:outputField title="Pre-Production Order" value="{!Opportunity.Pre_Production_Order__c}"/>
<apex:outputField title="1st Production Order" value="{!Opportunity.X1st_Production_Order__c}"/>
<apex:outputField title="Pre-Production Delivery" value="{!Opportunity.Pre_Production_Delivery__c}"/>
<apex:outputField title="1st Production Delivery" value="{!Opportunity.X1st_Production_Delivery__c}"/>
<apex:outputField title="Internal Selection Mtg" value="{!Opportunity.Internal_Selection_Mtg__c}"/>
<apex:outputField title="Buying Vehicle Identified" value="{!Opportunity.Buying_Vehicle_Identified__c}"/>
<apex:outputField title="Notification of Intent" value="{!Opportunity.Notification_of_Intent__c}"/>
<apex:outputField title="Contract Execution" value="{!Opportunity.Contract_Execution__c}"/>
<apex:outputField title="First Forecast Meeting" value="{!Opportunity.First_Forecast_Meeting__c}"/>
</apex:pageBlockSection>

<apex:pageBlockSection title="Decision Criteria/ Positioning (1/L =>5/H)" columns="2"> <apex:outputField title="Criteria/Goal # 1:" value="{!Opportunity.Criteria_Goal_1__c}"/>
<apex:outputField title="QLogic Positioning # 1:" value="{!Opportunity.QLogic_Positioning_1__c}"/>
<apex:outputField title="Competitor #1:" value="{!Opportunity.Competitor_1__c}"/>
<apex:outputField title="Competitor Positioning # 1:" value="{!Opportunity.Competitor_Positioning_1__c}"/>
<apex:outputField title="Criteria/Goal #2:" value="{!Opportunity.Criteria_Goal_2__c}"/>
<apex:outputField title="QLogic Positioning # 2:" value="{!Opportunity.QLogic_Positioning_2__c}"/>
<apex:outputField title="Competitor #2:" value="{!Opportunity.Competitor_2__c}"/>
<apex:outputField title="Competitor Positioning # 2:" value="{!Opportunity.Competitor_Positioning_2__c}"/>
<apex:outputField title="Criteria/Goal # 3:" value="{!Opportunity.Criteria_Goal_3__c}"/>
<apex:outputField title="QLogic Postioning # 3:" value="{!Opportunity.QLogic_Postioning_3__c}"/>
<apex:outputField title="Competitor #3:" value="{!Opportunity.Competitor_3__c}"/>
<apex:outputField title="Competitor Positioning # 3:" value="{!Opportunity.Competitor_Positioning_3__c}"/>
<apex:outputField title="Criteria/Goal # 4:" value="{!Opportunity.Criteria_Goal_4__c}"/>
<apex:outputField title="QLogic Positioning # 4:" value="{!Opportunity.QLogic_Positioning_4__c}"/>
<apex:outputField title="Competitor #4:" value="{!Opportunity.Competitor_4__c}"/>
<apex:outputField title="Competitor Positioning # 4:" value="{!Opportunity.Competitor_Positioning_4__c}"/>
<apex:outputField title="Criteria/Goal # 5:" value="{!Opportunity.Criteria_Goal_5__c}"/>
<apex:outputField title="Competitor Positioning # 5:" value="{!Opportunity.Competitor_Positioning_5__c}"/>
<apex:outputField title="Competitor #5:" value="{!Opportunity.Competitor_5__c}"/>
<apex:outputField title="QLogic Positioning # 5:" value="{!Opportunity.QLogic_Positioning_5__c}"/>
<apex:outputField title="Criteria/Goal # 6:" value="{!Opportunity.Criteria_Goal_6__c}"/>
<apex:outputField title="Competitor Positioning # 6:" value="{!Opportunity.Competitor_Positioning_6__c}"/>
<apex:outputField title="Competitor #6:" value="{!Opportunity.Competitor_6__c}"/>
<apex:outputField title="QLogic Positioning # 6:" value="{!Opportunity.QLogic_Postioning_6__c}"/>
</apex:pageBlockSection>

<apex:pageBlockSection title="Deal Amount Details" columns="2"> <apex:outputField title="Amount" value="{!Opportunity.Amount}"/> </apex:pageBlockSection>

<apex:pageBlockSection title="On-Going Revenue Details" columns="2"> <apex:outputField title="Total Amount for Current FQ" value="{!Opportunity.Total_Amount_for_Current_FQ__c}"/>
<apex:outputField title="Total Amount Q1" value="{!Opportunity.Total_Amount_Q1__c}"/>
<apex:outputField title="Total Amount Q3" value="{!Opportunity.Total_Amount_Q3__c}"/>
<apex:outputField title="Total Amount Q2" value="{!Opportunity.Total_Amount_Q2__c}"/>
<apex:outputField title="Total Amount Q4" value="{!Opportunity.Total_Amount_Q4__c}"/>
</apex:pageBlockSection>

<apex:pageBlockSection title="Special Pricing Request Required Information" columns="2"> <apex:outputField title="Primary Reason for SPR" value="{!Opportunity.Primary_Reason_for_SPR__c}"/>
<apex:outputField title="Ship Date From:" value="{!Opportunity.Ship_Date_From__c}"/>
<apex:outputField title="SPR Business Case Justification" value="{!Opportunity.Justification_Detail__c}"/>
<apex:outputField title="Ship Date To:" value="{!Opportunity.Ship_Date_To__c}"/>
<apex:outputField title="Approval Submission TimeStamp" value="{!Opportunity.Approval_Submission_TimeStamp__c}"/>
<apex:outputField title="Approval Complete TimeStamp" value="{!Opportunity.Approval_Complete_TimeStamp__c}"/>
</apex:pageBlockSection>

</apex:pageBlock>
</apex:page>

 
Is there a way to update a custom field on a the opportunity record with the approval comments from the fina approver?

 
We recently had "socalled" customers register on our Chatter Answer Self Registration page. However they claimed to be located in particular country but the Source IP address placed them in a country we did not do business in. Is their a way to prevent invdiviuals located in a particular country from registering?
I am recieving the following error but I am not sure why because I  have "</body" at the bottom of the page. 

Error Error: PDR_South_Central line 10, column 20: The element type "body" must be terminated by the matching end-tag "</body>"
Error Error: The element type "body" must be terminated by the matching end-tag "</body>".

Visualforce Email Template:
<messaging:emailTemplate subject="PDR Generated Prospect is Available for Follow-Up PDR: NA - South Central Seek List" recipientType="User" relatedToType="CampaignMember">
<messaging:htmlEmailBody > 
     <html>
        <body>
         <STYLE type="text/css">
               TH {font-size: 14px; font-face: arial;background: #CCCCCC; border-width: 1;  text-align: center }
               TD  {font-size: 14px; font-face: verdana }
               TABLE {border: solid #CCCCCC; border-width: 1}
               TR {border: solid #CCCCCC; border-width: 1}
         </STYLE></p>
                  <font face="arial" size="3">
        <p>Dear Salesforce User,</p>
        <p>New PDR Generated prospect(s)have been assigned to a your <b>PDR Generated</b> seek list and is now available for follow up in the following <b>Power Dialer</b> seek list:<p>
        <p><b>PDR Generated (NA - South Central)</b></p>
        <p>To launch the seek list, please click on the following link: <apex:outputLink value="https://na6.salesforce.com/{!relatedTo.id}">{!relatedTo.Name}</apex:outputLink></p>
<table border="1" >
<tr>
<table border="0" >
                 <tr >
                     <th>Prospect First Name</th><th>Prospect Last Name</th><th> Title </th><th> Phone </th><th> Email </th><th> State </th><th> Country </th><th>Company Name/th><th> Marketing Source</th>
                 </tr>
    <apex:repeat var="cam" value="{!relatedTo.CampaignMember}">
       <tr>
           <td>{!CampaignMember.FirstName}</td>
           <td>{!CampaignMember.LastName}</td>
           <td>{!CampaignMember.Title}</td>
           <td>{!CampaignMember.Phone}</td>
           <td>{!CampaignMember.Email}</td>
           <td>{!CampaignMember.State}</td>
           <td>{!CampaignMember.Country}</td>
           <td>{!CampaignMember.CompanyOrAccount}</td>
           <td>{!CampaignMember.Campaign})}</td>
           </tr>
    </apex:repeat>                
       </table>
        </body>
    </html>
</messaging:htmlEmailBody>
</messaging:emailTemplate>
I need to redirect the following domain: forums.qlogic.com to an existing force.com site.  How do I do this?

Force.com site: http://qlogic.force.com/SupportCenter/Customer_support_main
I have field on the opporutnity that gives the $ amount of the opportunity for the current fiscal quarter. The reason is for this is because we have opportunities that are on-going over the course of several quarters.  However not every deal is a 'on-going' opportunity. Therefore on the report the 'Total Amount for Current FQ' field displays $0.00 for some of the opportunities.

I want to create a custom formula in the report that will display the value of the 'Total Amount for Current FQ' field and if the value = $0.00, then display the Amount value instead. 

How would I write this formula?
  • Total_Amount_for_Current_FQ__c:SUM
  • AMOUNT:SUM
I appreciate the help!

 
The following errors were encountered while processing an incoming email:
 
CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY : SetTaskTypeToEmail: execution of BeforeInsert
 
caused by: System.NullPointerException: Attempt to de-reference a null object
 
Trigger.SetTaskTypeToEmail: line 6, column 1

I am not sure how to resolve this issue. It is a simple trigger. Please see code below. I appreciate any help. Thanks!
 
trigger SetTaskTypeToEmail on Task (before insert) {
For (Task nc:Trigger.new) {
String subject = nc.Subject;
String description = nc.Description;
If( subject != null && subject.startsWith('Email:') && description.startsWith('Additional To:')) {
nc.Type = 'Email';
}
}
}

 
I created a visualforce PDF page on the opportunity object. I am trying to create a hyperlink formual field to this VF page. This field will be used in opportunity reports. 

However when I click on the link, I recieve the following error:

This site can’t be reached
apex’s server DNS address could not be found.
DNS_PROBE_FINISHED_NXDOMAIN


Here is the formula that I have: HYPERLINK("https://apex/WinLossOpportunityReportPDF?Id="+ Id,"Win/Loss Opportunity Report","_parent")

User-added image
What am I doing wrong? I appreciate any help!

Thanks!
 
The parsing failed when I tried to generate an Apex Class from WSDL file. 
 
This is the error that I received - External schema import not supported.
 
Based on what I am reading in the forum, I need to do the following:
 
1. Inside <wsdl:types> (below the last <schema>) paste each referenced .xsd file content. Paste only <schema></schema>
2. Once all schemas are in the WSDL then comment all <xsd:import> using <!-- -->. They are no longer needed.
3. Please save changes and send back to me.

I am not the one who created the XML file and not sure how to update it with the instructions listed above? I apreciate any help!

Thanks!
 
<?xml version="1.0" encoding="UTF-8" ?>
<wsdl:definitions
     name="SerialInquiry"
     targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/http/QLogicConsolidatedApplication/QLSerialInquiryService/SerialInquiry"
     xmlns:tns="http://xmlns.oracle.com/pcbpel/adapter/http/QLogicConsolidatedApplication/QLSerialInquiryService/SerialInquiry"
     xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"
     xmlns:msg_in_out="http://www.qlogic.com/soaintegrations/Oracle/xsd/QLSerialInquiryServiceSchema"
     xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
     xmlns:plt="http://schemas.xmlsoap.org/ws/2003/05/partner-link/"
    >
    <wsdl:documentation>
        <abstractWSDL>https://fmwtest.qlc.com:8080/soa-infra/services/default/QLSerialInquiryService!1.0/SerialInquiry.wsdl</abstractWSDL>
    </wsdl:documentation>
    <plt:partnerLinkType name="Request_Response_plt">
        <plt:role name="Request-Response_role">
            <plt:portType name="tns:Request_Response_ptt"/>
        </plt:role>
    </plt:partnerLinkType>
    <wsdl:types>
        <schema xmlns="http://www.w3.org/2001/XMLSchema">
            <import namespace="http://www.qlogic.com/soaintegrations/Oracle/xsd/QLSerialInquiryServiceSchema"
                 schemaLocation="https://fmwtest.qlc.com:8080/soa-infra/services/default/QLSerialInquiryService/SerialInquiry?XSD=xsd/QLSerialInquiryServiceSchema.xsd"/>
        </schema>
    </wsdl:types>
    <wsdl:message name="SerialInquiryRequest_msg_in">
        <wsdl:part name="SerialInquiryRequest" element="msg_in_out:SerialInquiryRequest"/>
    </wsdl:message>
    <wsdl:message name="SerialInquiryResponse_msg_out">
        <wsdl:part name="SerialInquiryResponse" element="msg_in_out:SerialInquiryResponse"/>
    </wsdl:message>
    <wsdl:portType name="Request_Response_ptt">
        <wsdl:operation name="Request-Response">
            <wsdl:input message="tns:SerialInquiryRequest_msg_in"/>
            <wsdl:output message="tns:SerialInquiryResponse_msg_out"/>
        </wsdl:operation>
    </wsdl:portType>
    <wsdl:binding name="Request_Response_pttBinding" type="tns:Request_Response_ptt">
        <soap:binding transport="http://schemas.xmlsoap.org/soap/http"/>
        <wsdl:operation name="Request-Response">
            <soap:operation style="document" soapAction="Request-Response"/>
            <wsdl:input>
                <soap:body use="literal"/>
            </wsdl:input>
            <wsdl:output>
                <soap:body use="literal"/>
            </wsdl:output>
        </wsdl:operation>
    </wsdl:binding>
    <wsdl:binding name="Request_Response_ptHttpPOST" type="tns:Request_Response_ptt">
        <http:binding xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" verb="POST"/>
        <wsdl:operation name="Request-Response">
            <http:operation xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" location=""/>
            <wsdl:input>
                <mime:content xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" type="text/xml"/>
            </wsdl:input>
            <wsdl:output>
                <mime:content xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" type="text/xml"/>
            </wsdl:output>
        </wsdl:operation>
    </wsdl:binding>
    <wsdl:service name="SerialInquiry">
        <wsdl:port name="Request_Response_pt" binding="tns:Request_Response_ptHttpPOST">
            <http:address xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" location="https://fmwtest.qlc.com:8080/soa-infra/services/default/QLSerialInquiryService/SerialInquiry"/>
        </wsdl:port>
        <wsdl:port name="Request_Response_pt_soappt" binding="tns:Request_Response_pttBinding">
            <soap:address location="https://fmwtest.qlc.com:8080/soa-infra/services/default/QLSerialInquiryService/SerialInquiry"/>
        </wsdl:port>
    </wsdl:service>
</wsdl:definitions>

 
I am not strong in writing Apex Classes and Trigger and need assitance.

I am receiving the following error: Method does not exist or incorrect signature: populateRollUpFieldsOnOpportunity(newRecordsMap);

Here is the section of code for your reference. The error is on line 25. 
public with sharing class MultipleShipmentTrackingTriggerHandler {    
    public static set<Id> opptyIds = new set<Id>(); 
    public static boolean oliUpdateRunning = false;
    public static boolean doNotUpdateQuantity = false;
    public static boolean doNotUpdateAmount = false;
    
    public static void beforeInsertHandler(List<Multiple_Shipment_Tracking__c> newRecords){
        // validate the product , it must be from oppotunity line items
        validateProduct(newRecords);
        
        // populate fields on multiple shipment tracking record based on the valid product selected
        prePopulateFields(newRecords, false, null);     
    }
    
    public static void beforeUpdateHandler(Map<Id,Multiple_Shipment_Tracking__c> oldRecordsMap, Map<Id,Multiple_Shipment_Tracking__c> newRecordsMap){
        // validate the product , it must be from oppotunity line items
        validateProduct(newRecordsMap.values());            
        
        // populate fields on  multiple shipment tracking record based on the valid product selected
        prePopulateFields(newRecordsMap.values(), false, oldRecordsMap);
    }
    
    public static void afterInsertHandler(Map<Id,Multiple_Shipment_Tracking__c> newRecordsMap){
        // populate roll up calculation fields on opportunity
        populateRollUpFieldsOnOpportunity(newRecordsMap);
    }
    
    public static void afterUpdateHandler(Map<Id,Multiple_Shipment_Tracking__c> oldRecordsMap, Map<Id,Multiple_Shipment_Tracking__c> newRecordsMap){
        // populate roll up calculation fields on opportunity
        populateRollUpFieldsOnOpportunity(newRecordsMap);

 
I am a creating a custom VF page that renders as a PDF for the Opportunity object. See image below. I need to diplay the actiivty history related list on the opportunity in the VF page as a html table. Not sure how to do this. See image below. I appreciate the help!

User-added image
 
<apex:page standardController="Opportunity"  renderAS="pdf"> 
<html> 
   <head>
      <style>
        @page {size: A4 landscape; /* ISO/JIS A4 (210mm x 297mm) */  
                     margin: 5mm; 
                  } 
            @page:first {  
                     size: A4 landscape; /* ISO/JIS A4 (210mm x 297mm) */ 
                     margin: 5mm; 
                     margin-top: 3mm; 
    </style>                 
    </head>  
  </html>   
  
<apex:pageBlock title="{!Opportunity.name} Opportunity Dashboard {!Opportunity.LastModifiedDate}">
<TABLE BORDER="2" WIDTH="100%" style="border: solid gray;">
   <TR>
      <TD style="background-color:#dadae2; width:12%"><center><b>Coverage</b></center></TD>
      <TD><b>Sales:</b>{!Opportunity.Sales__c}</TD>
      <TD><b>SE:</b>{!Opportunity.SE__c}</TD>
      <TD><b>BU:</b>{!Opportunity.BU__c}</TD>
   </TR>
</TABLE>
<TABLE border="0" cellspacing="0" cellpadding="0" width= "100%">
<TR>
<TD WIDTH="33%"> 
<TABLE BORDER="2" WIDTH="100%" style="border: solid gray;">
   <TR>
      <TD style="background-color:#dadae2"><center><b>Opportunity Sizing</b></center></TD>
   </TR>
</TABLE>
<TABLE BORDER="2" WIDTH="100%" style="border: solid gray;">
   <TR>
      <TD><b>Deal Amount:</b>{!Opportunity.Actual_Amount__c}</TD>
   </TR>
</TABLE>
<TABLE BORDER="2" WIDTH="100%" style="border: solid gray;">
   <TR> 
      <TD><b>Q1:</b>{!Opportunity.Total_Amount_Q1__c}</TD>
      <TD><b>Q2:</b>{!Opportunity.Total_Amount_Q2__c}</TD>
      <TD><b>Q3:</b>{!Opportunity.Total_Amount_Q3__c}</TD>
      <TD><b>Q4:</b>{!Opportunity.Total_Amount_Q2__c}</TD>
   </TR>
</TABLE>
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">
   <TR>
      <TD style="background-color:#dadae2"><center><b>Decision Milestones</b></center></TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">
   <TR>    
      <TD style="background-color:#b5eaba;"><center><b>Event</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>Dates</b></center></TD>
   </TR>
   <TR>   
      <TD width="65%"><b>Evaluation Start and End Date:</b></TD>
      <TD><apex:outputText value="{0, date, MMMM d','yyyy}"><apex:param value="{!Opportunity.Evaluation_Start_Date__c}"/></apex:outputText>
-<apex:outputText value="{0, date, MMMM d','yyyy}"><apex:param value="{!Opportunity.Evaluation_End_Date__c}"/></apex:outputText></TD>
   <TR>  
     <TD><b>Evaluation DeBrief</b></TD>
     <TD>{!Opportunity.Evaluation_DeBrief__c}</TD>
   </TR>
   <TR>  
     <TD><b>Internal Selection Mtg</b></TD>
     <TD>{!Opportunity.Internal_Selection_Mtg__c}</TD>
   </TR>
   <TR>  
     <TD><b>Notification of Intent</b></TD>
     <TD>{!Opportunity.Notification_of_Intent__c}</TD>
   </TR>
   <TR>  
     <TD><b>Buying Vehicle Identified</b></TD>
     <TD>{!Opportunity.Buying_Vehicle_Identified__c}</TD>
   </TR>
    <TR>  
     <TD><b>Negotiation Start and End Date</b></TD>
     <TD><apex:outputText value="{0, date, MMMM d','yyyy}"><apex:param value="{!Opportunity.Negotiation_Start_Date__c}"/></apex:outputText>
-<apex:outputText value="{0, date, MMMM d','yyyy}"><apex:param value="{!Opportunity.Negotiation_End_Date__c}"/></apex:outputText></TD>
   </TR>
   <TR>  
     <TD><b>Contract Execution</b></TD>
     <TD>{!Opportunity.Contract_Execution__c}</TD>
   </TR>
   <TR>  
     <TD><b>First Forecast Meeting</b></TD>
     <TD>{!Opportunity.First_Forecast_Meeting__c}</TD>
   </TR>
   <TR>  
     <TD><b>Pre-Production Order</b></TD>
     <TD>{!Opportunity.Pre_Production_Order__c}</TD>
   </TR>
   <TR>  
     <TD><b>Pre-Production Delivery</b></TD>
     <TD>{!Opportunity.Pre_Production_Delivery__c}</TD>
  </TR> 
 </TR>
 <TR>  
     <TD><b>1St Production Order</b></TD>
     <TD>{!Opportunity.X1st_Production_Order__c}</TD>
  </TR> 
  <TR>  
     <TD><b>1St Production Delivery</b></TD>
     <TD>{!Opportunity.X1st_Production_Delivery__c}</TD>
  </TR>   
</TABLE>
<TD width="33%">
<TABLE BORDER="2" WIDTH="100%"  style="border: solid gray;">
   <TR>
      <TD style="background-color:#dadae2"><center><b>Decision Criteria Positioning (1/L =>5/H)</b></center></TD>
   </TR>
</TABLE>
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">
   <TR>    
      <TD width="60%" style="background-color:#b5eaba;"><center><b>Criteria/Goal</b></center></TD>
      <TD width="20%" style="background-color:#b5eaba;"><center><b>QLogic</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>{!Opportunity.Competitor_1__c}</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>{!Opportunity.Competitor_2__c}</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>{!Opportunity.Competitor_3__c}</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>{!Opportunity.Competitor_4__c}</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>{!Opportunity.Competitor_5__c}</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>{!Opportunity.Competitor_6__c}</b></center></TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">   
   <TR>  
     <TD width="60%">{!Opportunity.Criteria_Goal_1__c}</TD>
     <TD width="20%">{!Opportunity.QLogic_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_6__c}</TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">   
   <TR>  
     <TD width="60%">{!Opportunity.Criteria_Goal_2__c}</TD>
     <TD width="20%">{!Opportunity.QLogic_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_6__c}</TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">   
   <TR>  
     <TD width="60%">{!Opportunity.Criteria_Goal_3__c}</TD>
     <TD width="20%">{!Opportunity.QLogic_Postioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_6__c}</TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">   
   <TR>  
     <TD width="60%">{!Opportunity.Criteria_Goal_4__c}</TD>
     <TD width="20%">{!Opportunity.QLogic_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_6__c}</TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">   
   <TR>  
     <TD width="60%">{!Opportunity.Criteria_Goal_5__c}</TD>
     <TD width="20%">{!Opportunity.QLogic_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_6__c}</TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">   
   <TR>  
     <TD width="60%">{!Opportunity.Criteria_Goal_6__c}</TD>
     <TD width="20%">{!Opportunity.QLogic_Postioning_6__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_1__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_2__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_3__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_4__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_5__c}</TD>
     <TD>{!Opportunity.Competitor_Positioning_6__c}</TD>
   </TR>
</TABLE>   
<TABLE BORDER="2" WIDTH="100%"  style="border: solid gray;">
   <TR>
      <TD style="background-color:#dadae2"><center><b>Key Player Match-Up</b></center></TD>
   </TR>
</TABLE>
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">
   <TR>    
      <TD width="60%" style="background-color:#b5eaba;"><center><b>Customer Contact</b></center></TD>
      <TD style="background-color:#b5eaba;"><center><b>Title</b></center></TD>
   </TR>
</TABLE> 
<TABLE BORDER="2" WIDTH="100%" style="border:solid gray;">
 <TR>  
     <TD>Name:{!Opportunity.Customer_Contact_1__c}</TD>
     <TD>{!Opportunity.CustomerContact_Title_1__c}</TD>
   </TR>
   <TR>  
     <TD>Name:{!Opportunity.Customer_Contact_2__c}</TD>
     <TD>{!Opportunity.Customer_Contact_2__c}</TD>
   </TR>
   <TR>  
     <TD>Name:{!Opportunity.Customer_Contact_3__c}</TD>
     <TD>{!Opportunity.CustomerContact_Title_3__c}</TD>
   </TR>
</TABLE>
<TD width="33%">
</TD>
</TD>
</TD>
</TR>
</TABLE>
</apex:pageBlock>
</apex:page>

 
Is there a way to update a custom field on a the opportunity record with the approval comments from the fina approver?

 
I am recieving the following error but I am not sure why because I  have "</body" at the bottom of the page. 

Error Error: PDR_South_Central line 10, column 20: The element type "body" must be terminated by the matching end-tag "</body>"
Error Error: The element type "body" must be terminated by the matching end-tag "</body>".

Visualforce Email Template:
<messaging:emailTemplate subject="PDR Generated Prospect is Available for Follow-Up PDR: NA - South Central Seek List" recipientType="User" relatedToType="CampaignMember">
<messaging:htmlEmailBody > 
     <html>
        <body>
         <STYLE type="text/css">
               TH {font-size: 14px; font-face: arial;background: #CCCCCC; border-width: 1;  text-align: center }
               TD  {font-size: 14px; font-face: verdana }
               TABLE {border: solid #CCCCCC; border-width: 1}
               TR {border: solid #CCCCCC; border-width: 1}
         </STYLE></p>
                  <font face="arial" size="3">
        <p>Dear Salesforce User,</p>
        <p>New PDR Generated prospect(s)have been assigned to a your <b>PDR Generated</b> seek list and is now available for follow up in the following <b>Power Dialer</b> seek list:<p>
        <p><b>PDR Generated (NA - South Central)</b></p>
        <p>To launch the seek list, please click on the following link: <apex:outputLink value="https://na6.salesforce.com/{!relatedTo.id}">{!relatedTo.Name}</apex:outputLink></p>
<table border="1" >
<tr>
<table border="0" >
                 <tr >
                     <th>Prospect First Name</th><th>Prospect Last Name</th><th> Title </th><th> Phone </th><th> Email </th><th> State </th><th> Country </th><th>Company Name/th><th> Marketing Source</th>
                 </tr>
    <apex:repeat var="cam" value="{!relatedTo.CampaignMember}">
       <tr>
           <td>{!CampaignMember.FirstName}</td>
           <td>{!CampaignMember.LastName}</td>
           <td>{!CampaignMember.Title}</td>
           <td>{!CampaignMember.Phone}</td>
           <td>{!CampaignMember.Email}</td>
           <td>{!CampaignMember.State}</td>
           <td>{!CampaignMember.Country}</td>
           <td>{!CampaignMember.CompanyOrAccount}</td>
           <td>{!CampaignMember.Campaign})}</td>
           </tr>
    </apex:repeat>                
       </table>
        </body>
    </html>
</messaging:htmlEmailBody>
</messaging:emailTemplate>
I need to redirect the following domain: forums.qlogic.com to an existing force.com site.  How do I do this?

Force.com site: http://qlogic.force.com/SupportCenter/Customer_support_main