Find Jobs
Hire Freelancers

Automate Open PO Report

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
Automate report to email a list of open PO's to suppliers with a click of a button with the following language in the email. "This is an automated message from Hoyt Archery in Salt Lake City, Utah to " & vendorname & ". Attached is a list of all open orders. Please review these open orders for accuracy to ensure that they are currently in process and confirm the estimated delivery dates. If there are any late line items (highlighted in red), please use the attached file and complete the 'Recovery Plan' field to update Hoyt Archery as to the status and plan for each of the late items. Please return the document to " & BuyerEmail & " at Hoyt within 2 business days. Please do not respond directly to this email. Thank you. Hoyt Archery" Orders should be sorted by Supplier name, then Delivery Date. All late orders (orders that have reached the delivery date) should be be background red, font white. The file that is sent to the supplier should be in .xls format with the final column titled "Recovery Plan".
Project ID: 17609989

About the project

11 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to add the necessary functionality to send an Excel file as attachmen. I've delivered almost 240 projects in the last 5 years and this makes me very comfortable with your task. I can deliver the project within 7 days including all required revisions for $120. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon. Paris Pallas
$120 USD in 7 days
4.9 (219 reviews)
7.2
7.2
11 freelancers are bidding on average $159 USD for this job
User Avatar
Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 385 + projects with 100% client satisfaction. I can help you with Automate Open PO Report I have more than 5 years of the experience in Data Processing, Excel, Microsoft Access, Software Architecture, Visual Basic Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. Thanks.
$200 USD in 3 days
4.9 (323 reviews)
7.8
7.8
User Avatar
Hi! Is this a Microsoft Access related project? If so, what email client you are using - Outlook? If both are "yes", we can use Outlook object model to generate an email and attach a report. Regarding report - in what format we are going to send it - PDF as an attachment? Regards, Branislav Mihaljev
$155 USD in 3 days
5.0 (247 reviews)
7.3
7.3
User Avatar
I have read your project description. I feel I am qualified to assist. I have 19 years experience in Access and Excel. My expertise is Access and Excel databases and complex spreadsheets. I have taken all classes from 07 to 13 beginner to expert. If you would like to discuss the project further or want samples please don't hesitate to message me. I have screenshot samples on my profile. either way I wish you the best of luck and I hope you get the design you invitation. Have a blessed night.. Donna
$138 USD in 2 days
4.8 (40 reviews)
6.5
6.5
User Avatar
Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you develop this automated app using Outlook or SMTP as a sending option. I already have similar programs and will tweak it to your needs. PS: please note that you added Excel in your project skills, this will flood your project with unreliable bidders who come from Excel Data Entry background. Looking forwards to hearing from you. Best, Alaeddin
$111 USD in 1 day
5.0 (70 reviews)
5.8
5.8
User Avatar
I know how to mail reports along with attachments through Excel and Access, with required formatting. I have excellent command on MS Excel and Access. I have completed complex projects in Excel and Access before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$180 USD in 2 days
4.9 (91 reviews)
6.0
6.0
User Avatar
Hi, I've done order management / email jobs before and can deliver a Windows desktop software solution for you based on your requirements and workflow. Good quality work done, and will be available for support in future. Thanks for considering me. -Steve
$240 USD in 5 days
4.8 (75 reviews)
6.3
6.3
User Avatar
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
$150 USD in 2 days
5.0 (27 reviews)
5.3
5.3
User Avatar
I have vast experience in MS Excel, MS Access, VBA, SQL, MS SQL etc. I have overall 10+ years of experience.
$150 USD in 3 days
5.0 (18 reviews)
4.8
4.8
User Avatar
Hi, I have done many web scraping projects and I am very good in Excel, VB Macros etc. I have 15 years of IT experience. If you would like to see a sample of my work before you can accept my bid, please give me a milestone so I can prove that I will meet your expectations. I can do your project in 2 days. I will create a standard executable which will sort the excel data by supplier name, delivery date. I will highlight them with colors as advised and save the excel as .xls file. The executable will then read the list of supplier emails provided and then proceed to prepare the email body embedding the Supplier name and buyer name as required and attach the preformatted excel file. It will be one seamless operation on a button click. All I (the executable) would expect from you is to input the excel file path and Vendor's email/Buyer's email Once you accept my bid, I promise to be available to you on phone and email from 10 am to 10 pm PST (US Time). Please accept my bid if you think I know my job. Thanks for reading thru. Have a nice day there. Thanks - Mona C
$155 USD in 3 days
5.0 (3 reviews)
2.0
2.0
User Avatar
Dear sir, I'm sure that I can complete your project 'Automate Open PO Report' as soon as possible. I am senior software developer and always provide fast service. I promise a high quality and punctual work. Please try me! :) Skills: Data Processing, Excel, Microsoft Access, Software Architecture, Visual Basic,
$155 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Salt Lake City, United States
4.9
15
Payment method verified
Member since Feb 23, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.