Lukket

Write me a VBA Script or Powershell

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

Evner: Excel, Visual Basic, Visual Basic for Apps, VB.NET, Databehandling

Se mere: write spider script, sqlserver write file script, write perl script send logs, free vba script macro, write introduction script, vba script automated email, start vba script excel, write perl script match name, write mssql script, run vba script excel, hyperlink vba script outlook, vba script copy object word, excel vba script modify existing vba, vba script message forward, vba script access, vba script paste, write vba script outlook 2007, vba script write outlook alert, vba script write sql

Om arbejdsgiveren:
( 0 bedømmelser ) London, United Kingdom

Projekt ID: #20899368

28 freelancere byder i gennemsnit £161 på dette job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Flere

£200 GBP in 2 dage
(722 bedømmelser)
8.5
schoudhary1553

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. Flere

£220 GBP in 5 dage
(334 bedømmelser)
8.0
asin1987

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 Flere

£250 GBP in 7 dage
(176 bedømmelser)
7.5
khanicha

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 Flere

£111 GBP på 1 dag
(20 bedømmelser)
7.8
dvcontact

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 specifi Flere

£150 GBP in 7 dage
(50 bedømmelser)
6.3
nvchien94

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 dage
(126 bedømmelser)
5.8
valor312

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 http Flere

£135 GBP på 1 dag
(50 bedømmelser)
5.7
DevStar925

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 Flere

£135 GBP in 7 dage
(3 bedømmelser)
5.0
StormLion227

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert VBA programmer on freelancer.com and I do not bid on pro Flere

£135 GBP på 1 dag
(19 bedømmelser)
5.1
khoddam

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 dage
(28 bedømmelser)
5.0
desconit

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 an Flere

£80 GBP på 1 dag
(13 bedømmelser)
5.1
teamapp

Dear Customer, Here we have read your project "Write me a VBA Script or Powershell I have carefully read your requirements and understood the project. We have some more questions, please send us a message to discuss Flere

£235 GBP in 5 dage
(2 bedømmelser)
4.1
writingapp

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 dage
(9 bedømmelser)
4.1
ielucerotrad1

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 Flere

£250 GBP in 7 dage
(11 bedømmelser)
3.7
prolonedev

-> Expert C# Software Application Developer Greetings! I have taken good interest working on your Script. I have gone through the details and assessed that using C# is the better route around. However if you would in Flere

£225 GBP in 3 dage
(3 bedømmelser)
3.6
finest2019

Hello. Here is data processing manager. I have all coditions that appropriate your requirement. I have just read your requirement at carefully. I'm an expert of data processing by using many Excel macros such as DAX, p Flere

£100 GBP in 2 dage
(3 bedømmelser)
2.9
adeelpirzada

Hello, i have done scrapping almost on Half of Worldwide web including eCommerce giants (Amazon, eBay, craigslist) News Feed, Social media websites, API's. I develop my own scrapers and Bots based on requirement Flere

£175 GBP in 7 dage
(4 bedømmelser)
4.1
pnjadhav

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 Flere

£300 GBP in 7 dage
(4 bedømmelser)
2.5
faiiz

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 vi Flere

£130 GBP in 2 dage
(2 bedømmelser)
1.9
Rogedomo

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 Flere

£135 GBP in 7 dage
(0 bedømmelser)
0.0