Find Jobs
Hire Freelancers

Macros Excel Project, Modifications on an automatic email existing platform

$30-250 AUD

Cerrado
Publicado hace alrededor de 4 años

$30-250 AUD

Pagado a la entrega
Hi we have a Macros excel platform where they can send emails by vendors by product classifications. we use that platform to dispatch our products everyday. the plat form generate order numbers, convert the accounts name to our custom name and use our format on the email subject and body and we need a bidding on that existing platform, we need to make some changes . 1 We have manual emails from spreadsheet and need a bulk individual email options for each vendor, one click 20 separate emails will go to the same vendor with 20 different our custom subjects. 2 when we process order manually and click on the Column B hyperlink and once the email open the cell color will automatically turn into yellow. 3 Any Customer name and address matches/duplicate in the spreadsheet column A will turn into red for the both 1st and 2nd or 3rd..... duplicate lines 4 if column K value is over $999 then place a note under column A "QUANTITY" Context that -"High value product please include a free Signature delivery on regular shipping cost" is can be add or delete by Vendors name 5. once we ran macros create 4 columnn A for Code B for manual email hyperlink C quantites and d for make model and year 6. attach all pdf attachments to the email from same directory if if the P.O number matches with the email subject p.o number. 7. add an option to put control over the attachment group, we can select which group need attachment or not, if attachment not found with the p.o number then the group email will provide the error massage with the missing p.o number from subject. 8 According to column F order number generate and add name on the subject like Order : Brian and the number 1, also need to add a date on the order subject. 10 After successfully process the group email change color or the cells
ID del proyecto: 24113841

Información sobre el proyecto

22 propuestas
Proyecto remoto
Activo hace 4 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 INDIA
faridabad, India
4,9
37
Forma de pago verificada
Miembro desde mar 9, 2017

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.