Find Jobs
Hire Freelancers

Copy Outlook Subject to Microsoft Excel - repost

$10-30 AUD

Cancelado
Publicado hace más de 10 años

$10-30 AUD

Pagado a la entrega
Hi, I want to copy email subject that meets certain criteria from Microsoft Outlook to Microsoft Excel. Every day I have an excel file with the name "Office Running Sheet - dd-mm-yy" So every day I will have an excel file with different file name but with the above format. This file will be always in the same folder location. Excel file attached. Data copied from Outlook will be paste into Column N starting from Row 21. Please Note: 1. The excel file is actively used every second, we use autofilter a lot, sorting and hiding rows, will this be a problem? 2. If Excel file is active or in say 'F2' mode, macro can check Excel's status and, if busy, it can add a recurring task in Outlook to export the data to Excel. Whenever, macro detects that Excel is free, it can send the data. 3. There will also a manual data entry to the excel file that is also very active, around 7 manual data entry every minute. So the code will need to check the cells left to it. Example: before putting a data to cell N21, it needs to check if cell B21 to M21 is empty? if yes then put the data. if not, then go to cell N22, and check again if cell B22 to M22 is empty? if yes, then put the data. If not, then go to cell N23, and so on. 4. I need a button or something that can switch this code off instantly, just in case things go wrong. You can write a macro on my excel, or on my outlook, or use another plugin, or whatever. Up to you as long as this goal is accomplished. Criteria on Email Subject to be copied: - If the first 3 letters are POS - If the first letter is R then followed by 3 digit numeric number. Example: R261 - If the first letter is W then followed by 3 digit numeric number. Example: W410 - If the first letter is D then followed by 3 digit numeric number. Example: D201 I want the code to be dynamic so that in the future I can set my own criteria. Thanks, Bryan
ID del proyecto: 5094609

Información sobre el proyecto

1 propuesta
Proyecto remoto
Activo hace 11 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
1 freelancer está ofertando un promedio de $30 AUD por este trabajo
Avatar del usuario
Hello, I can provide you desktop application using Vb.Net to read outlook subject. thanks Kalpesh
$30 AUD en 3 días
4,5 (17 comentarios)
4,9
4,9

Sobre este cliente

Bandera de AUSTRALIA
Bellevue Hill, Australia
5,0
5
Forma de pago verificada
Miembro desde sept 9, 2013

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.