Copy Outlook Subject to Microsoft Excel - repost 2

Cancelled Posted Nov 4, 2013 Paid on delivery
Cancelled Paid on delivery

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

Visual Basic

Project ID: #5094660

About the project

8 proposals Remote project Active Nov 11, 2013

8 freelancers are bidding on average $52 for this job

finecodervw

Hi, Let me introduce myself as an expert VB programmer. I have worked on VB versions 3.0,4.0,5.0 and 6.0 with back ends like MS Access 97,2000, 2003, 2007,2010 SQL Server and Oracle. I have more than 10 years of More

$222 AUD in 10 days
(54 Reviews)
5.4
expertatwork

hey Bryan, we are again here :-) Please let us know if you are ready to discuss further, thanks !

$45 AUD in 3 days
(18 Reviews)
3.9
FahimAhamed

Hi Bryan, If you check my work history, one out of the two jobs that I have done has some similarity to the job you have described. I have ample experience in dealing with vba for both excel and outlook. i believe tha More

$35 AUD in 3 days
(1 Review)
3.8
gaysusi

We have visual Basic agents and can complete the task, kindly give me more details to start. So that we can start ASAP

$25 AUD in 3 days
(0 Reviews)
0.0
dock34

Dear employer, I have strong skills in VBA, Excel and Data Mining. As a student, I have been doing multiple projets in VBA during the last 3 years and I really seem to enjoy it. I would be a pleasure to help you an More

$25 AUD in 3 days
(0 Reviews)
0.0
Ashishkapadiya

I have worked in Outlook macro. In our company, that I was making this macro., I know that all the macro. If you want, I give you my demo. Give me the job, I will give you time to finish. OutLook macro I have more expe More

$15 AUD in 3 days
(0 Reviews)
0.0
gsuperinis

Yes i know i don't have reviews, but all starts from 0. If You choose me i will work hard and You will be happy with my results. Also i will do this quickly, because now i don't have job, so i will spend all my time on More

$25 AUD in 3 days
(0 Reviews)
0.0
Senthiltechno

We have good expertise in VB .You can be assured of a quality output from us. Looking forward to hear from you thanks Senthil

$23 AUD in 3 days
(0 Reviews)
0.0