Find Jobs
Hire Freelancers

413071 Automated Email Sending

N/A

In corso
Pubblicato circa 14 anni fa

N/A

Pagato al completamento
Hi, I am an online seller , accepting payments through paypal . I need a solution having a system to automatically email buyers their tracking number with ease. The webserver used to send the emails should be in white list meaning it will not go into SPAM/JUNK mails by standard emails provider. Requirement: Please open the attachment [login to view URL] workbook -> ORDERS2010b sheet (which is my orders tracking excel). Look in to column E (Seller Account) ,column F(Item) ,column G (Buyer Name) , Column H + Column I + Column J (Buyer Full Address), Column M (Buyer Email) , Column Q (Tracking Number) The system should be able to process the rows of orders I have selected and automatically send emails to buyers using predefined messages accordingly. Note : There are 3 different Tracking Number Type : 1> Hong Kong Post (Tracking number Ends with HK) 2> Singapore Post (Tracking number Ends with SG) #) EMS China (Tracking number Ends with EMS) _____________________________________________________________________ Standard Email Message: To: "Column M" Subject: Tracking number for your order "Column F" ( Seller: "Column E) Dear "Column G", Thank you for your purchase . We have shipped your item and the tracking number is as below: Tracking Number : "Column Q" Tracking Website : "According to Condition Con1 Below" Con1 Condition= If country is United States Tracking Website is [login to view URL] else Other Countries Look in to Column Q and see if what is the Ending Code for the Tracking Number (HK OR SG OR CN) IF HK Tracking Website = [login to view URL] IF SG Tracking Website= [login to view URL] IF CN Tracking Website= [login to view URL] Thank you for purchasing with us. We have got the tracking number of your item from our dropshipper. Item has been shipped on but it seems to take slightly longer in custom clearance from dropshipper location . It is on the way to you. NORMAL DURATION: ("Duration" "According to Condition Con2" Below) weeks delivery time usually after date of item shipped. If Column J= Unites States , United Kingdom ,Canada Duration =2-3 Else =3-6 We offer 100% CUSTOMER SATISFACTION for all products At any time when you receive it and you are not satisfied you can contact us for a claim Sorry for any delays. Kindly hold on till delivery. Thank you. _____________________________________________________________________
Rif. progetto: 2158933

Info sul progetto

Progetto a distanza
Attivo 12 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite

Info sul cliente

Bandiera: MALAYSIA
Kuala Lumpur, Malaysia
4,3
10
Membro dal lug 30, 2009

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.