Find Jobs
Hire Freelancers

Write me a VBA Script or Powershell

£20-250 GBP

Closed
Posted over 4 years ago

£20-250 GBP

Paid on delivery
Hi, I'm looking to automate the downloading of timesheets for staff that work for my company. Currently the staff are emailing their timesheets as attachments and the attachments are downloaded using a macro which runs once a week. I would like to go a step further and downlaod these attachments as they come in: I would like the attachments from emails to be saved automatically (pictures e.g PDF, jpeg, png). I would like the name of the attachments to be: the name of the sender** + date of the month + time of day + ascending number. I would like the attachments to be saved automatically to a folder which corresponds to the week number ( Yearly calendar). I’ve done an example below: If I get an email from Anne Jones (Annyj93348@[login to view URL]) on 10th April 2019 at 17:30 with 2 attachments then the program/macro will automatically save the 2 attachments like this: O:\Company Name\Timesheets\Week 15\Anne Jones 1004 1730 [login to view URL] O:\Company Name\Timesheets \Week 15\Anne Jones 1004 1730 [login to view URL] If I get an email from Anne Jones (Annyj93348@[login to view URL]) on 13th September 2019 at 09:22 with 6 attachments then the program/macro will automatically save the 6 attachments like this: O:\Company Name\Timesheets\Week 37\Anne Jones 1309 0922 [login to view URL] O:\Company Name\Timesheets \Week 37\Anne Jones 1309 0922 [login to view URL] O:\Company Name\Timesheets\Week 37\Anne Jones 0504 0922 [login to view URL] O:\Company Name\Timesheets \Week 37\Anne Jones 0504 0922 [login to view URL] O:\Company Name\Timesheets\Week 37\Anne Jones 0504 0922 [login to view URL] O:\Company Name\Timesheets \Week 37\Anne Jones 0504 0922 [login to view URL] **To get the name of the sender, this will be in the outlook contact list
Project ID: 20899368

About the project

23 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
23 freelancers are bidding on average £159 GBP for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
£220 GBP in 5 days
4.9 (399 reviews)
8.1
8.1
User Avatar
Dear Employer, I understand you need to save the attachments from emails with a particular format. I will do this job for you. I am an expert with over 12 years of experience and will do a perfect job asap. Please do check my previous reviews once for your kind consideration!! :) Thanks and Regards, Ash
£250 GBP in 7 days
5.0 (213 reviews)
7.9
7.9
User Avatar
Hello, If you consider in using Outlook addin which will monitor the incoming messages and process them automatically, I could arrange a super quick solution. It is a VBA macro installed within your Outlook, so once user opens the Outlook and starts to receive new messages then the macro will process automatically. So no schedule and no user interaction Using this method, the script will be ready in a day
£111 GBP in 1 day
4.4 (30 reviews)
7.9
7.9
User Avatar
Hello there, I am an VBA dev and I create 1 script run in Outlook to complete this task for you. It will take 1 day to complete then u can test. If you are using outlook now let contact me. Thanks.
£100 GBP in 2 days
5.0 (214 reviews)
6.5
6.5
User Avatar
Hi, Would you like to see a quick demo of your project on developing a program that will automatically and immediately download the Timesheet attachment sent by email by employees and save them in a folder in a specific naming format completed before you award the project? You can consider it professionally done in less than 24 hrs. I am confident I can exceed your expectations since I am accustomed to doing this sort of job on a regular basis. I am highly skilled in the following areas: 1. Excel 2. Data Entry 3. Visual Basic 4. Excel Macro 5. Visual Basic for Apps I am passionate about flawless results and I can assure you of a job well done. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time.
£150 GBP in 7 days
4.9 (60 reviews)
6.6
6.6
User Avatar
VERY EASY FOR ME, I can do it within a few hours Hi, Nice to meet you. When it comes to Excel, Google Sheet, VBA, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/projects/excel/need-calculate-KPI-scoring-matrix/?w=f https://www.freelancer.com/projects/excel/Excel-Macro-pull-data-from/?w=f https://www.freelancer.com/projects/excel/Excel-VBA-Time-Series-Decomposition-20459676/?w=f https://www.freelancer.com/projects/excel/Build-appraisal-record-card/?w=f https://www.freelancer.com/projects/visual-basic-for-applications/Connect-Word-Userform/?w=f https://www.freelancer.com/projects/excel/Need-HELP-this-excel-form/?w=f https://www.freelancer.com/projects/php/create-outlook-add-rule-shortcut/?w=f https://www.freelancer.com/projects/data-entry/add-excel-table-rows-outlook/?w=f https://www.freelancer.com/projects/excel/Convert-Text-file-XML-file/?w=f https://www.freelancer.com/projects/data-entry/excel-expert-19406573/?w=f https://www.freelancer.com/projects/excel/Compare-CSV/?w=f https://www.freelancer.com/projects/excel/ascii-excel-converter/?w=f https://www.freelancer.com/projects/software-architecture/Excel-xml-file-online-wizard/?w=f https://www.freelancer.com/projects/software-architecture/Combination-creator/?w=f After complete project, I can support fixing bugs with free. and support update features with low price. Please contact me. Thanks
£135 GBP in 1 day
5.0 (63 reviews)
6.3
6.3
User Avatar
Hi there, My suggestion is using Microsoft Flow, it listens for incoming emails and according the pre defined conditions and senders, takes appropriate action
£120 GBP in 4 days
5.0 (39 reviews)
5.4
5.4
User Avatar
Hi. Great app writer for your projects. I have writen powershell, excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
£90 GBP in 5 days
4.9 (63 reviews)
5.5
5.5
User Avatar
Hi, I have over 7 years of industry experience in VB6, VB.net and macros(VBA). I can write a program/macro which will extract time sheets from email and save in the designated folders as mentioned Relevant Skills and Experience In the project description. Additionally a log will be created which will give you the summar of attachments saved in the folder. e.g number of attachments for an employee etc.
£80 GBP in 1 day
5.0 (13 reviews)
5.1
5.1
User Avatar
Hi, Dear Employer! I am really interested in your project. I have enough experience in Powershell, VBA, Python, C/C++, C#, java programming. I am 100% sure I can satisfy your requirements perfectly. I want a long-term relationship with you. Thank you and best regards!
£135 GBP in 7 days
5.0 (3 reviews)
5.0
5.0
User Avatar
I can do the job! I read and no problem, macros would integrate outlook (done project saving emails to different folders) , excel and file managment. I'm assuming files are on a local area network or sharepoint address. If awarded we can talk through details. About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Office and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).
£250 GBP in 7 days
5.0 (25 reviews)
4.4
4.4
User Avatar
Hi Sir I am interrested in this project. My name is Faiz and im an Actuary and a professional data scientist, a combination that provides me with the full suite of tools to do data analysis, data modelling and data visualization using VBA. I promise you for a quality work at an effordable price on time. Expecting a reply soon. Thank you.
£130 GBP in 2 days
5.0 (6 reviews)
3.1
3.1
User Avatar
Sending attachments in e-mail messages through Outlook is something I've done several automations using only Visual Basic for Applications (Excel, Access, Outlook). Choose me for this job. I have been a VBA specialist for 20 years.
£134 GBP in 4 days
5.0 (4 reviews)
2.9
2.9
User Avatar
I am working with skills that you required for this job from 16 years. I am working with VB 6.0,COM,ActiveX,MS Access,Excel,MS SQL and VBA from long time. I can definitely help you in this job, to make your database design very proficient. I have done lots of split databases with MS Access as Front-end and MS Access/MS SQL/MySQL/Teradata database as back-end. You'd also be delighted to know that I have acquired the Information Technology extensive education, that's why I'm confident that I can be a great asset to your organization. I am willing to work for 40 hours per week to help you with your project. Please contact me with your interest to discuss next.
£300 GBP in 7 days
5.0 (4 reviews)
2.5
2.5
User Avatar
Hello Sir/Madam. My name is FATIMA and writing is my passion “When I say work, I only mean writing. Everything else is just an odd job”. From my early age, I enjoyed reading novels and stories, as I was growing up it has become my passion now. I am professionally active in the field of writing since 2010 for my clients on different platforms. Thank you
£20 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I can handle this project. I am Microsoft technology specialist and have 10 years of strong hands on experience in desktop, web and mobile application development. I can work for you as time and cost model. please ping me on skyp - segmentsonline Core skills - ASP.NET webforms, MVC, WPF MVVM, XAMARIN, C#, VB. NET, JQUERY,SignalR, ANGULAR4, NodeJS, BOOTSTRAP, SQL SERVER,MONGODB, NOSQL. Outlook add-in, SSRS reports, excel/pdf reports...etc Experienced in Express,Hapi,Angular4, NodeJS,Javascript,Css, VBA Macro Experienced in LEGO robotes, mindwave, reply interact keypad integration, Experienced syncfusion controls, infragestics controls Recently I have successfully completed multiple WPF applications for german and uk customers through another portal.. Two are quite complex projects with hardware integration. Thanks, Kris
£355 GBP in 12 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi!, I'm a engineer with a good experience in VBA codes. So, I can do the job perfectly. I want work in this project like a practice to applying my knowledge. Best regards
£135 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been working with vba for the past couple of years in my fulltime job. This task looks pretty straight forward, as I have done similar interactions with gmail. Please contact me for any questions.
£135 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, My Engineering and BPO experience as Analyst/Developer should be enough for the task. In terms of your needs, revision of your current macro/vba will or just code from scratch should accomplish the objective. The given project delivery is on the safe side, yet i'm sure it would be less than 7 days. My data process and analyst ability is a value added if needed. Lastly i do have the time. Thank you -Regards, Rogelio
£135 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have years of experience with VB (including .NET) and have done automation of office applications before, such as Outlook. I presume you are currently receiving e-mails into an Outlook client? I can do the saving of new e-mail attachments quite easily and the sorting into the appropriately named folders will be a little extra logic that I see as quite easy to implement. Please consider me for this project. Thank you, Mark.
£200 GBP in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
0.0
0
Member since Aug 21, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.