Đã Đóng

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

Kĩ năng: Excel, Visual Basic, Visual Basic cho Ứng dụng, VB.NET, Xử lí dữ liệu

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) London, United Kingdom

ID dự án: #20899368

28 freelancer đang chào giá trung bình £161 cho công việc này

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 Thêm

£200 GBP trong 2 ngày
(722 Nhận xét)
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. Thêm

£220 GBP trong 5 ngày
(334 Nhận xét)
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 Thêm

£250 GBP trong 7 ngày
(176 Nhận xét)
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 Thêm

£111 GBP trong 1 ngày
(20 Nhận xét)
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 Thêm

£150 GBP trong 7 ngày
(50 Nhận xét)
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 trong 2 ngày
(126 Nhận xét)
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 Thêm

£135 GBP trong 1 ngày
(50 Nhận xét)
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 Thêm

£135 GBP trong 7 ngày
(3 Nhận xét)
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 Thêm

£135 GBP trong 1 ngày
(19 Nhận xét)
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 trong 4 ngày
(28 Nhận xét)
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 Thêm

£80 GBP trong 1 ngày
(13 Nhận xét)
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 Thêm

£235 GBP trong 5 ngày
(2 Nhận xét)
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 trong 5 ngày
(9 Nhận xét)
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 Thêm

£250 GBP trong 7 ngày
(11 Nhận xét)
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 Thêm

£225 GBP trong 3 ngày
(3 Nhận xét)
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 Thêm

£100 GBP trong 2 ngày
(3 Nhận xét)
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 Thêm

£175 GBP trong 7 ngày
(4 Nhận xét)
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 Thêm

£300 GBP trong 7 ngày
(4 Nhận xét)
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 Thêm

£130 GBP trong 2 ngày
(2 Nhận xét)
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 Thêm

£135 GBP trong 7 ngày
(0 Nhận xét)
0.0