======  ======


EFax is a service that allows you to email to a fax machine.  Once setup, you can send an email to 


<html><div style="margin-left: 20px;"> 1nnnnnnnnnn@efaxsend.com </div></html>


with an attached PDF or Word document and it will then send the fax to the fax number in the email.  For more information on the service, including pricing, see http://www.efax.com.


===== Concept =====


The challenge was to configure the email address using the fax address.  The email address supports the use of mail merge fields, but unfortunately I was not able to get the fax number to work and build the address there.  It had problems of containing dashes, spaces, etc. which are rejected by eFax.


So, I created a contact UDF to store the formatted fax number and used a SQL Query (attached to the menu) to update the eFax numbers before I sent them out.  Then I referenced the UDF field in the email address and it took care of the problem.


===== Cautions =====


Perfect this with __one__ order before sending it en masse'.


===== Steps =====
  - Create a Contact UDF called **EFax Number** (with a space between) of type text.
  - Restart Control so the UDF is created.
  - Create a SQL Report in the main menu with query in the next section.
  - Run the SQL Report to update the UDFs.  (Note, because this happens in SQL and Control doesn't know about it, you may not see it if you already had the customer record open.  If you close Control and restart it should be there.)
  - Open a test order (preferably one where you are the ordered).
  - Send a test email, using the UDF containing the efax email address ...


<html><div style="margin-left: 20px;"> **** </div></html>


==Query to Update the Contacts UDF==


<code sql>
update AccountContactUserField
set eFax_Number = (Select 
                      case when Substring(FaxNumber, 1, 1) not in ('0', '1') 
                      then '1'+FaxNumber 
                      else FaxNumber 
                      end + '@eFaxSend.com' 
                    from
                    (
                        select ID as ContactID, AccountID,
                           SecondaryNumber, SecNumberTypeID, SecNumberTypeText,
                           REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(SecondaryNumber, '(', ''),')', ''), '-', ''),' ', ''), '.', ''), '011+', '011'), '+', '011')
                           as FaxNumber
                        from AccountContact AC
                        where SecondaryNumber is not null 
                          and LEN(RTrim(SecondaryNumber)) > 12
                          and SecNumberTypeID = 11
                    ) TempFax
                    where ContactID = ID
                    )
where ID in (Select ID 
             from AccountContact AC
             where SecondaryNumber is not null 
                   and LEN(RTrim(SecondaryNumber)) > 12
                   and SecNumberTypeID = 11
             )
</code>


===== Source =====


Contributor: Team Cyrious


Date: 5/2010


Version: Control 5.0+