Find Jobs
Hire Freelancers

An Excel/Outlook Macro

$30-250 AUD

Cerrado
Publicado hace más de 9 años

$30-250 AUD

Pagado a la entrega
Hi all, I need a macro that runs on Outlook 2010 and does the following: 1. Open the excel attachment (the email would only have one attachment). 2. In Excel, go to Data, then Filter the headers 3. check whether cell "J1" is equal to a particular string, if so, use filter for column "J" and select "none". If not, abort. 3. check whether cell "O1" is equal to a particular string, if so, use filter for column "O" and select today's date (this column is dates). If not. abort. 4. column "H" is currencies. column "I" is amounts, for each currency, sum the amount in column "I". Normally there are 3 to 4 currencies. 5. Then the macro should generate an email with such information in the subject: the currency and its sum for each currency from step 4. The email's from, to fields are also specified (it's fixed and do not change). My signature should also be placed in the email. Any questions please let me know. Thanks very much. Kind Regards, Jason
ID del proyecto: 6953947

Información sobre el proyecto

13 propuestas
Proyecto remoto
Activo hace 9 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
13 freelancers están ofertando un promedio de $114 AUD por este trabajo
Avatar del usuario
Aucune proposition n'a encore été fournie.
$111 AUD en 2 días
4,9 (28 comentarios)
5,0
5,0
Avatar del usuario
Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$83 AUD en 1 día
5,0 (40 comentarios)
4,8
4,8
Avatar del usuario
Hi, I'm VBA developer and I already worked on half of this project Please share some sample mails with attachments and mail format to send mails with subject line how you want to run it? 1) as per date condition - by default, tool will run as per today's date and download each attachment and process your 4 conditions and will save attachment. 2) Automatically mail will generate with To, Subject & your signature but you didn't mentioned mail body format? Please PM me means i can start working on same and share demo with you before award this project Thanks
$225 AUD en 3 días
5,0 (3 comentarios)
3,5
3,5
Avatar del usuario
Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office.
$50 AUD en 1 día
4,9 (10 comentarios)
3,6
3,6
Avatar del usuario
I'm a expert of Outlook Plugin development, I developed many Outlook plugin/macros during my work. All my bidding projects here are related to Office plugin, I finished them on time and got very good feedback, and you can refer to my finished projects for this. It's easy to use VBA macro to manipulate excel file, read the content, filter and calculate data, and finally send mail according to your requirement. It would be great if you can give me the sample excel file.
$88 AUD en 5 días
4,9 (5 comentarios)
3,7
3,7
Avatar del usuario
I'm an MS Office expert and I am proficient with working with VBA in Excel, Outlook as well as Word and Access. The specification seems to be straightforward and I could start working on your project straight away Let me know if you would like to accept my bid Regards Morris
$70 AUD en 2 días
4,8 (5 comentarios)
3,3
3,3
Avatar del usuario
Hi you can look at my porfolio and projects. I am quite knowledgable in Macros and get this job completed for you in 2 days.
$100 AUD en 3 días
5,0 (3 comentarios)
2,6
2,6
Avatar del usuario
A proposal has not yet been provided
$111 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i have design similar macro Excel files ! Excel as you desire can be completed in day and also it can be modified in future by means of variable programmable fields.
$100 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can make this with a macro without problem. The only thing that we should review is the Outlook permisions to send files authomatically, for security (if enabled) your account will ask for confirmation (an accept button ) prior sending any email. I can deliver and make about two corrections after delivery if i am selected. Regards
$66 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Since i have used excel through out my 14 years of my career ,where my day to day reports which required lot of automation which where automated by me with the help of macro
$250 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello there, I frequently write macros that extract data from excel. This will be easy for me to complete in a timely manner.
$111 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de INDIA
Pondicherry, India
0,0
0
Miembro desde ene 5, 2015

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.