Find Jobs
Hire Freelancers

VBA in ACCESS for Open Invoices, Contact Customer

$30-250 USD

Completed
Posted about 4 years ago

$30-250 USD

Paid on delivery
In MS Access, want to be able to query the invoice table for unpaid invoices, then organize them by customer and Invoice Number. Then grabbing the email address and sending each customer a separate email with the Unpaid invoice information in the body of the text as a Table. There may be more than one email address to send to (and/or) multiple CC addresses. There are in Access 2 tables 1- Open Invoices by Invoice Number and Line Items and 2- Second table is Customer Table with email addresses and names Query all Invoice Line Items that are open/due by over 45 days, Lastly Send a Log (Table in email or attached excel file) of all emails sent out (with email addresses) and Invoices that are overdue, by line items and date due, and send Log to another email address (internal to Us)
Project ID: 24474432

About the project

28 proposals
Remote project
Active 4 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
Hi Robert. Thanks for inviting me to bid. Please contact me when you will be available. Many thanks. Best Regards, Issam
$200 USD in 5 days
4.9 (329 reviews)
7.9
7.9
28 freelancers are bidding on average $158 USD for this job
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Access developer. According to your brief, you want to have an Access database upgraded so that it runs some queries and sends updates through email messages. I will charge you $180* and can deliver within three days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Access and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 360 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$180 USD in 3 days
4.9 (451 reviews)
8.2
8.2
User Avatar
Hello! I can help you with that. Are you using Outlook as an email program? If you do, I'll write a code to utilize the Outlook object model (late binding) which allows us to have full control over email. Best regards, Branislav Mihaljev
$140 USD in 2 days
5.0 (299 reviews)
7.9
7.9
User Avatar
Hi there,I am VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to initiate the chat so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$140 USD in 2 days
4.9 (166 reviews)
7.8
7.8
User Avatar
Hello! Are you planning to use Outlook to send email? Contact me to discuss the details. I can start working on your project immediately. From the Microsoft Access and vba macro, of course, familiar. Regards, Vladimir
$100 USD in 2 days
4.9 (250 reviews)
7.1
7.1
User Avatar
*** Dear, I AM EXPERT MS ACCESS DATABASES *** I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project ? I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$60 USD in 3 days
4.7 (93 reviews)
7.4
7.4
User Avatar
Hi, Would you like to see a quick demo of your Invoice table for unpaid Invoices Queried and Organized by customer and invoice number before you award the project? You can consider it professionally done in a few hours. Rather than fill this proposal with a list of qualifications, I want to complete a part of this project as a proof of concept before you award this project. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time
$150 USD in 5 days
4.9 (66 reviews)
6.9
6.9
User Avatar
Hello, I am ready to discuss project with you. Being experienced in working on several Ms Access projects of various complexities, based on that i can help you design solution you need for invoices, sending mails etc. as given in the description. Looking forward to have further project discussion on chat. Thanks. Vimal Arora
$110 USD in 4 days
4.8 (185 reviews)
6.4
6.4
User Avatar
Hi, I'm an expert Access database and Windows application software developer, with significant experience in developing email applications, as the one you described. I am confident that I can develop the addition to your Access database, and can deliver in 3 days or less. Good quality work done. Good quality, reliable work done, and long term support service offered. Thanks for considering my bid. Best wishes, Steve ~ Larry Anselof Technology Solutions - Providing a quality and reliable freelance software development service since 2004 ~
$240 USD in 3 days
4.9 (53 reviews)
6.1
6.1
User Avatar
As a professional business analyst with over 15 years experience building automated solutions using Access, VBA & SQL, I have worked extensively with invoice management / debtor communications. I would love the opportunity to take a look at your existing system which may assist me to refine my quote. From looking at your requirements I would make some quick suggestions: 1. Rather than having a hard limit set on 45 days, make this a user input that defaults to 45 days (that way you have some more flexibility) 2. Have the option to include / exclude people who have already been emailed in the last [x] days 3. Have the option to change the subject line of the emails according to whether it is first /second / third etc. reminder It would be great to chat further about your project!
$120 USD in 7 days
5.0 (33 reviews)
5.5
5.5
User Avatar
Hello, Hope you are doing well and safe. Your project is related to my area of expertise. I would like to take care of your project and I can assure you that I can provide best and long term support. I have similar invoicing database which i can show you live or send screen shot over personal chat. Invitation over personal chat would be highly appreciated. Thank you
$200 USD in 3 days
4.9 (33 reviews)
5.8
5.8
User Avatar
Hi there, I have done email automation using VBA, Outlook and MS Access before and can do your job quickly and professionally. I have lots of experience in VBA and automation. I have a couple of questions. Please send me a message to discuss further, if you like. Looking forward.
$70 USD in 2 days
5.0 (14 reviews)
5.0
5.0
User Avatar
Respected Sir, Yours is a straight forward requirement as compared with functionality of an Order Manager Program for E-Commerce Business. Over the years I have developed an in house advanced reporting solution to filter a report by any column with any criteria and sorting by any column. All these tasks are performed after generating the report in live. Just ping me back so that I can attach screenshots .My brief intro goes here: I m a VB.net & especially MS Access developer, continuously writing more user friendly applications in VB.Net, MS Access-VBA and many more. Recently working on Stone Edge Order Manager customization automation and Designing Custom Reports (for better Business Intelligence) from last 5 years which can integrate with more than 55 online leading shopping carts. I have already developed many complex business solutions for different small and medium organizations. You can analyse sample work done by me before finalizing the project. Guarantee of quality work done with more user friendly and automatic environment, 100% accuracy and attention to detail. Normally I go above and beyond the requirements. I'll appreciate if you manage some time for live meeting on Team Viewer so that I can show glimpse of my working. Please feel free to communicate for further info and ping me so that I can upload some sample stuff that how rich MS Access Forms development capability I have. Kind regards, Farrukh Rehman CEO Intelligent Software Solutions.
$200 USD in 2 days
4.9 (26 reviews)
5.0
5.0
User Avatar
Greetings! My name is Sergey, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA/SQL: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and commented, client gets whole access and rights for the code I made. Warranty covers any bugs detected later. In the case described I have 2 questions: - do you already have a template for Invoice? - do you use Outlook as email sender? Looking forward for further clarifications of details. Regards, Sergey
$100 USD in 7 days
4.9 (14 reviews)
4.7
4.7
User Avatar
Hi! I read your project details. I have good knowledge on MS Access with VBA and perfect on Database management Management System. I can deliver the completed job within the time frame. I'm really organized and pay attention to detail. I'm available to start immediately. Please contact me via chat. Thanks. Rita
$250 USD in 7 days
4.9 (4 reviews)
3.8
3.8
User Avatar
Hi, I am ready to perform your requirements in access vba for "VBA in ACCESS for Open Invoices, Contact Customer" to extract data from access tables and send them by emails. I have experience in MS SQL server,asp.net, crystal reports and VB.net more than 12 years. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - University of Syria-Aleppo - year 2006. Programming and database specialized, expert in vb.net and SQL server with all versions, Crystal reports, also expert in iis and Windows servers 2005, 2008, 2012… Other skills: C#,asp.net, Php, my sql , technical & Sage ACCPAC ERP support, SQL Replication, Excel vba and macros, Access vba, Microsoft office(Word, Excel, PowerPoint, Access). Best Regards. Khaled Alflah
$230 USD in 7 days
4.9 (15 reviews)
3.6
3.6
User Avatar
get free sample hello i'm interested in your project i have 10 years experience in this field I was Created many application with visual Basic , C# Programming and database please check my portfolio
$180 USD in 7 days
5.0 (3 reviews)
3.2
3.2
User Avatar
Dear Employer I have been through through your requirements. I can build a query that will filter out the customer and customer information as per the criterion and you can send emails using VBA buttons that I will add in the final interface. Regards Payal Rana
$111 USD in 3 days
5.0 (4 reviews)
2.5
2.5
User Avatar
Hi Greetings of the Day, I am interested in this task, I have extensive exp in macro writing. CURRENTLY I AM DOING ON ACCESS/VBA PROJECTS ONLY. I am full time freelancer carrying 15 yrs of experience in VBA, Web and Windows development and Mobile development using ASP.Net, C#, SQL server, Xamarin, WebAPI, XML, Cr Reports etc. I have extensive experience in writing VBA/Excel codes/macros. Please feel free to contact me. Thanks
$190 USD in 7 days
5.0 (1 review)
1.8
1.8
User Avatar
I am very good in VBA, MS Access and can deliver this work with best quality in a short time on 2 - 3 days .
$100 USD in 3 days
5.0 (2 reviews)
1.8
1.8
User Avatar
I am an engineer i know that skill that u have mentioned here..i will complete the project with in tje mentioned time limit
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Cedar Grove, United States
5.0
8
Payment method verified
Member since Jul 6, 2016

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.