Find Jobs
Hire Freelancers

Sending automatic e-mail with attachment above 25 MB.

$30-250 USD

Kapalı
İlan edilme: 7 yıldan fazla önce

$30-250 USD

Teslimde ödenir
*** 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.
Proje No: 11648718

Proje hakkında

18 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 7 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
18 freelancers are bidding on average $131 USD for this job
Kullanıcı Avatarı
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 1 gün içinde
5,0 (136 değerlendirme)
6,1
6,1
Kullanıcı Avatarı
I am an expert in delivering custom scripts and look forward to discuss further details about the project
$222 USD 6 gün içinde
4,8 (5 değerlendirme)
4,5
4,5
Kullanıcı Avatarı
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 7 gün içinde
5,0 (10 değerlendirme)
3,8
3,8
Kullanıcı Avatarı
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 3 gün içinde
5,0 (5 değerlendirme)
2,4
2,4
Kullanıcı Avatarı
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 3 gün içinde
5,0 (2 değerlendirme)
1,7
1,7
Kullanıcı Avatarı
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 7 gün içinde
5,0 (2 değerlendirme)
1,7
1,7
Kullanıcı Avatarı
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 3 gün içinde
5,0 (1 değerlendirme)
0,8
0,8
Kullanıcı Avatarı
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 0 gün içinde
5,0 (1 değerlendirme)
0,4
0,4
Kullanıcı Avatarı
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 3 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
A proposal has not yet been provided
$111 USD 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 3 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 3 gün içinde
5,0 (2 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 3 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 5 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 3 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   CHILE bayrağı
Santiago, Chile
5,0
3
Ödeme yöntemi onaylandı
Eyl 11, 2016 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.