En curso

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

Please see "Master [url removed, login to view]" 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 [url removed, login to view]” – This is the one to be updated

“Customer [url removed, login to view]” –To be used to update “Order here” tab

“Discount [url removed, login to view]” – To be used to update “Product List” tab

“Anglo Aquatic Availability List 26th March 2017 Brackenwood Plant & Garden centre [url removed, login to view]” - An example of a completed spread sheet

“Anglo Aquatic Availability List 26th March 2017 Brackenwood Plant & Garden centre [url removed, login to view]” 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

Habilidades: Manejo de email, Excel

Ver más: software write mq4, software write chip epson, useful software write book, software write web specs, software write edid, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, lock excel spread sheet, software write technical manual

Información del empleador:
( 6 comentarios ) Enfield, United Kingdom

ID de proyecto: #13471365

Adjudicado a:

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 Más

£130 GBP en 5 días
(5 comentarios)
2.5

18 los freelancers están ofertando un promedio de £151 para este trabajo.

£200 GBP en 2 días
(427 comentarios)
7.8
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 informatio Más

£150 GBP en 3 días
(159 comentarios)
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 ex Más

£150 GBP en 2 días
(133 comentarios)
6.4
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. Más

£133 GBP en 3 días
(39 comentarios)
5.5
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 en 3 días
(75 comentarios)
5.2
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 Más

£100 GBP en 3 días
(6 comentarios)
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 wou Más

£150 GBP en 3 días
(10 comentarios)
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 en 3 días
(1 comentario)
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 en 1 día
(2 comentarios)
0.7
ImBillUK

Hello, We are Gifted Solutions, a Digital Creative Agency based in the UK. We have over 15 years experience in the skills needed to complete this project. We have looked over your requirements and we are confi Más

£132 GBP en 7 días
(0 comentarios)
0.0
£20 GBP en 3 días
(0 comentarios)
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 Micr Más

£133 GBP en 2 días
(0 comentarios)
0.0
vikasroy63

Hello, I have gone through the project details and I understand your requirements well. You need an excel spreadsheet to be prepared and automated. The project requires some excel data linking with complicated macro Más

£300 GBP en 3 días
(0 comentarios)
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 Más

£122 GBP en 30 días
(0 comentarios)
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. Tha Más

£250 GBP en 3 días
(0 comentarios)
0.0
£23 GBP en 3 días
(0 comentarios)
0.0
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 regard Más

£173 GBP en 3 días
(0 comentarios)
0.0