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

  • Tình trạng Đã Đóng
  • Ngân sách £20 - £250 GBP
  • Tổng Lượt Chào Giá 18

Mô Tả Dự Án

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

Nhận báo giá miễn phí cho dự án tương tự
Đã trao cho:
Các kỹ năng yêu cầu

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

  • Hãy đặt mức ngân sách và khung thời gian của bạn
  • Mô tả đề xuất của bạn
  • Nhận thanh toán cho công việc của bạn

Thuê những Freelancer đã đặt giá trong dự án này

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online