Find Jobs
Hire Freelancers

413071 Automated Email Sending

N/A

En curso
Publicado hace alrededor de 14 años

N/A

Pagado a la entrega
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. _____________________________________________________________________
ID del proyecto: 2158933

Información sobre el proyecto

Proyecto remoto
Activo hace 12 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos

Sobre este cliente

Bandera de MALAYSIA
Kuala Lumpur, Malaysia
4,3
10
Miembro desde jul 30, 2009

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.