Find Jobs
Hire Freelancers

Sending automatic e-mail with attachment above 25 MB.

$30-250 USD

Chiuso
Pubblicato più di 7 anni fa

$30-250 USD

Pagato al completamento
*** I WILL NOT CONTACT ANYONE BY CHAT THAT DON'T READ WHAT I'M ASKING AND SEND A GENERIC PROPOSAL. *** All days at 06:00 am I've to send an e-mail with a report that comes from an SQL Database on Microsoft SQL SERVER in .xlsx format (excel) . The query remains the same, and the SQL table updates automatically each minute. Process is: 0) Windows Task Manager to open .xlsx files at 05:50 am 1) Open .xlsx file and macro autorun 2) Update Table and make report. (take some minutes) 3) Save Updated File. 4) Send e-mail through Microsoft Outlook with attachment via VBA. This is very easy to program, I'm not expert at all but I've coded it on VBA, and it's had been working fine for some time. MY PROBLEM IS THAT A NEW REPORT I'M SENDING DAILY THE FILE IS BIGGER THAN 20 MB, SO IT'S NOT POSSIBLE TO BE SENT BY OUTLOOK. Now I've to manually save it on Google Drive, get the sharing link, and send it on the e-mail. I need an automated solution for this. Waking at 05:50 all days is not ok for me. I've tried to compress the file, but even when compressing it with Winrar it's still above 20 mb. The Database is huge for .xlsx. I would send it as a back up file but final users don't have SQL knowledge, and the report includes lots of graphics, etc. Splitting the file is NOT AN OPTION. (that would mean end-user would have to copy-paste it back in one file) Using a .CSV file is not an option either, because .xlsx have multiple sheets and graphics, formula etc. I have Google App for work paid in my Office, so if you find some way to make an script for google app to send the file automatically AFTER updating the .xlsx with Google Drive using sharing link mode-on would be OK. Also my company have a website with Ipage hosting contracted as provider, with Hosting Essential Plan. Using this webpage for this would be even better. This approach would be: Uploading it AUTOMATICALLY at certain hour to the webpage, and adding a marker that says: File last Updated was at 06:00 28 September 2016. I WILL NOT CONTACT ANYONE BY CHAT THAT DON'T READ WHAT I'M ASKING AND SEND A GENERIC PROPOSAL.
Rif. progetto: 11648718

Info sul progetto

18 proposte
Progetto a distanza
Attivo 7 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
18 freelance hanno fatto un'offerta media di $131 USD
Avatar dell'utente
I run a small web hosting company and have been in IT for about 15 years. I'm no programmer and certainly no VBA wizard, but I have automated things over the years and have an analytical mind. I think your last approach would be best, since it keeps things simple and doesn't depend on even more services, which can change, like Google. It shouldn't be rocket surgery to get FTP working out of the VBA and adding a little code to the webpage for a marker. That way the file is uploaded and the e-mail is fired off with just a link to it. The only issue with this approach is that the file would be accessible to the world unless we password-protect the directory, which is pretty easy in a linux host. Should be no big deal in IIS, either, if you happen to be using that.
$111 USD in 1 giorno
5,0 (136 valutazioni)
6,1
6,1
Avatar dell'utente
I am an expert in delivering custom scripts and look forward to discuss further details about the project
$222 USD in 6 giorni
4,8 (5 valutazioni)
4,5
4,5
Avatar dell'utente
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details
$166 USD in 7 giorni
5,0 (10 valutazioni)
3,8
3,8
Avatar dell'utente
Hello Sir. I have 5 years of experience in software and specially in bot development. Its a very easy task. I am interested to work for you on this project. Just message me so that we can start waiting for your positive response :)
$155 USD in 3 giorni
5,0 (5 valutazioni)
2,4
2,4
Avatar dell'utente
There are more solutions for your problem and the easiest is to avoid attachment size limitation. If you are happy with this solution I'll lower my bid and explain you how to do this. Uploading file to website is also not a problem, but I need to know few things like which protocol can be used (ftp, ftps, sftp, ...) for uploading files. Please contact me if you are interested in my proposal.
$60 USD in 3 giorni
5,0 (2 valutazioni)
1,7
1,7
Avatar dell'utente
This should be done using vbscript on Windows as it gives a lot of flexibility. also you should use it only to open excel at 5 50 and then the excel file should check the time is between 5 50 and 6 if so then run the macro. there are lot more issues to cover like uploading which is not easy at all automatically.
$150 USD in 7 giorni
5,0 (2 valutazioni)
1,7
1,7
Avatar dell'utente
Hi I have done something like this. I will use your hosting smtp to send your big files. i will automate ALL the proccess. Let's talk.
$250 USD in 3 giorni
5,0 (1 valutazione)
0,8
0,8
Avatar dell'utente
Hi, Just a thought but could you not use your existing script to generate the file automatically and then use a basic command line batch file (set on a timer) to copy and overwrite the file to a web server directory, Dropbox folder or Google drive sync directory and just provide the link to the same file each day? I figured you might have been overthinking it and missed a simple solution that you don't have to pay for. Kind regards, Mark
$30 USD in 0 giorno
5,0 (1 valutazione)
0,4
0,4
Avatar dell'utente
Greetings, I can assist you with te required task. I could have a look at the option with google or also we could discuss the alternative in uploading file to the web server. Thanks for your time. Regards,
$100 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
$111 USD in 7 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hi, I can upload file on webpage with C# Selenium library. You must send me the web so I can see what is needed to do. The script will be written in C# like Console application and must be running in background checking time. Then, when it is the time, method will be triggered and file will be uploaded. That's all simply as written above. Contact me for more information. Greetings, Domagoj
$155 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Have you looked at using pcloud and posting the file. You could use vba to post it to pcloud and the user gets an email with a button to download your file. Pcloud is free service. I can implement this if you wish
$150 USD in 3 giorni
5,0 (2 valutazioni)
0,0
0,0
Avatar dell'utente
I have past experience in sending file to google drive and sharing the same over email have used c# before. However, if you would like to provide me with a try could get it done with VBA also, If not c# can be guranteed as back which will make sure that the data is transmitted and also, will keep a track of each sent and failure statuses. In event of failure can also, cause some alarms or any other option like and sms depending upon your requirement.
$133 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hello, I would like to help you with your project. I am very skilled with SQL Servers and the automatism of them. Your basic problem seems to be the automatic mail delivery. If you choose me I would need to have access to your server, so i can try my ideas in productive enviroment. I'm looking forward to hearing from you. Sincerely cheapandeasy
$100 USD in 5 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hello, simple FTP mini-server would solve this problem... can have same characteristics as email, it is just as using a different client for that.. unlimited data transfer! size
$155 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: CHILE
Santiago, Chile
5,0
3
Metodo di pagamento verificato
Membro dal set 11, 2016

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.