Modify an Excel spread sheet and email it to customers using Mozilla Thunderbird

£20-250 GBP

Đã hoàn thành

Đã đăng vào

khoảng 7 năm trước

£20-250 GBP

Thanh toán khi bàn giao

Please see "Master [login to view URL]" Instructions tab for detailed instructions You will write a program that can perform 2 steps. The first will prepare a spread sheet by hiding certain rows and locking certain cells. We then manually adjust the sheet before we run the next step. The second will insert data from two different excel files into the spread sheet and send the main sheet to the appropriate email address via Mozilla Thunderbird (NOT Outlook). Your program will also attach a pdf copy of one of the main “Order here” worksheet tab. Please note, we send over 900 emails so it must only take a few seconds to process each order. We send them to the outbox and then Thunderbird slowly sends them to not overload the email system. The simper we keep it the better as that offers me most flexibility in future! I have attached; “Master Availability [login to view URL]” – This is the one to be updated “Customer [login to view URL]” –To be used to update “Order here” tab “Discount [login to view URL]” – To be used to update “Product List” tab “Anglo Aquatic Availability List 26th March 2017 Brackenwood Plant & Garden centre [login to view URL]” - An example of a completed spread sheet “Anglo Aquatic Availability List 26th March 2017 Brackenwood Plant & Garden centre [login to view URL]” An example of a pdf to be sent Please note in the examples I have only hidden and locked the first few rows. In the example Customer details I have used my email for all to avoid the risk of sending to a customer! The sooner I can have this the better, ideally by Thursday but that might be too tight. If you think you can do it but not in the £250 budget let me know. Thanks Caroline

Email Handling

Excel

Mã dự án: 13471365

Về dự án

18 đề xuất

Dự án từ xa

Hoạt động 7 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@draco77

Hello Caroline. My plan to done this project. Create new "Control" workbook with 2 buttons and configuration part. First button will create xls/xlsx files for all clients from list. Second button will create pdfs and send emails to clients (can i use emails from prepared files?) Configuration section parts: - path to list of clients - path to master availality file - output path for xls and pdf files (are this files should be deleted after send?) - Mail configuration: - subject text - text swich to select text of file - body text - body html path - optional bcc field I pretty sure that is all.

£130 GBP trong 5 ngày

4,9

(5 nhận xét)

2,5

18 freelancer chào giá trung bình £151 GBP cho công việc này

@mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

£150 GBP trong 3 ngày

4,9

(159 nhận xét)

6,7

@schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply

£150 GBP trong 2 ngày

4,9

(133 nhận xét)

6,4

@tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start

£150 GBP trong 3 ngày

4,8

(75 nhận xét)

5,2

@sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards

£133 GBP trong 3 ngày

4,5

(39 nhận xét)

5,5

@nimesha1994

Hi, I'm very interested to do your project. I have great knowledge on about your project. I have already read your description and I feel like I would be a great fit for the project. I can start your project right now. I have extensive web search and data entry experience. I have huge knowledge Data entry advantage other task easily and having ability to give back to you fine result. So you can select me for a good result. # My objective is to provide 100% fast and accurate service to my client. # Organize data before inputting. # Attention to detail and accuracy when inputting information. # knowledgeable in microsoft office. I;m hard worker and my goal is client satisfaction to provide the best quality services. Thank You for your time and consideration. sincerely, Nimesha

£100 GBP trong 3 ngày

5,0

(6 nhận xét)

4,2

@pgbhughes

I would not worry about the Mozilla middle layer. If we have an SMTP mail server setting, then I would use the standard methods in VBA to do this. I have done it before to login to send mails via gmail. Typically I would write the code in Excel, leave it in VBA, and then use that as the middle layer for handling the mails. If you have a time issue, we can put in a delay between each mail, or scheduler to do the mailing at set pace. Given your timeline this is quite tight, but if I have the mail server information then I can re-use code from a previous project which does this. It was for a sales guy in Indonesia who mails about 100 odd service providers, with weekly sales documents. I would actually create a dummy excel document with only the information you want to share, and not hide things. Leave it as values only i.e. copy and paste to sheet and then attach that temporary file. That is how I normally do it. Using standard SMTP objects in VBA this can be done. Please ping me if you want more information. Regards - Paul

£150 GBP trong 3 ngày

4,9

(10 nhận xét)

3,2

@rzwnqau

I am expert in working on Excel spread sheet. Given my expertise I assure you to deliver the given project adhering to the given instructions completely. Looking forward. RIzwan

£249 GBP trong 3 ngày

5,0

(1 nhận xét)

1,7

@sergioobici

Hello, I'm an Italian professional specialized in developing web based application and db interfaces. I am accurate ,precise and my goal is the customer satisfaction. I'd be glad to collaborate with you

£144 GBP trong 1 ngày

5,0

(2 nhận xét)

0,7

@SGSgraphics

Hello, I hope all is good. I have well experienced in this field about 7+ years. I am very dedicated person and i think i can definitely fulfill your requirement. I have read Your project description regarding project very carefully. I am ready to start your work immediately and would like to deliver your project timely. I like to make every possible solution of my client's problem and i will be my pleasure to start a work with you. If you like You can check my profile & Portfolio here and then make a decision. I will give you 101% best output from my end so that you consider me only for future job :) Apart from all this i want to build a long term relationship with you. Infact i regularly keep you updated regarding the project you are giving me and make you satisfied. For Graphical work Please check My Freelancer Portfolio. I can share more once you contact me Thanks simer

£173 GBP trong 3 ngày

0,0

(0 nhận xét)

0,0

@anannaa

Dear Hiring Manager Thank you very much for reviewing my cover letter. I ’m an expert on Email Marketing, Data Entry, MS Word, Excel, with some year’s experiences. I am greatly interested in your project with all of your necessities. Recently I have successfully completed this type of project in another marketplace. In Freelancer.com, I am new. I also have worked in local market. If you give me chance, you will be found a quality work. I am always available on Email and Skype. Please have a voice or video chat if necessary. I will be available most of the time in a day and able to start your project any time according to you & I will try my best. Best Regards, Mst. Shahina Khatun

£122 GBP trong 30 ngày

0,0

(0 nhận xét)

0,0

@marielangelic

Hi, I am interested with your job posting as a data entry freelancer. I am good with copy and pasting data into spreadsheets. I am very keen on details. I am a fast worker. I follow instructions. I am good with Microsoft word,excel, power point and google docs. I make sure my work is understandable and that the data will be useful to the part of the end users. I always finish my task on time and I am a fast worker. I don't like errors so I always do quality assurance to my work. I can start as soon as when you want me to. I am good with web research and I always make sure to get the correct datas needed. Hope to hear from you soon.

£133 GBP trong 2 ngày

0,0

(0 nhận xét)

0,0

@itopfresh

A good excel expert with a whole lot of experience.O will give u a good job delivered right on time. Buh I'll be more comfortable with 350-450 pounds. Just trust me with this project and Let me give you a good job. Thanks

£250 GBP trong 3 ngày