
Closed
Posted
Paid on delivery
I need a simple, reliable workflow that lets me trigger Outlook to email invoices automatically based on rows in an Excel sheet. The sheet will already contain all recipient information, file paths, and any text that should appear in the body of the message. Each invoice is already saved as a PDF. Here’s what I want the finished solution to do: • Read each active row of my Excel list, pick up the email address, customer name and the matching PDF file location. • Generate a personalised email in Outlook, attach the correct PDF, and fill in a subject line and body text pulled from the same row (or a common template if that is cleaner). • Send the message right away—or optionally save it to Drafts if I flip a flag in the spreadsheet. • Mark the row as “Sent” (date-time stamp) so the same invoice is never mailed twice when I rerun the routine. I am comfortable keeping everything inside Office 365, so VBA in Excel, a VSTO add-in, or a Power Automate flow are all fine; I just want something that launches with a click and does not stall on security prompts. Please build and test on the current Outlook/Excel desktop versions. Once delivered I will consider the job done when I can drop your file in my environment, update the folder paths, press the button, and see the emails go out exactly as intended.
Project ID: 40536269
14 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average ₹9,436 INR for this job

I created invoice autoamtin to pdf and aut outlook email sending integration, take a look at my past completed similar works and clients' reviews from links below. Regards. https://www.freelancer.com/projects/data-processing/data-processing-use-mail-merge/reviews https://www.freelancer.com/projects/excel/Excel-Auto-Execute-Macro-Upon/reviews https://www.freelancer.com/projects/excel/Fix-excel-VBA-36198376/reviews
₹12,500 INR in 2 days
5.4
5.4

With nearly a decade of experience in web and mobile development, I have built a solid expertise in automation - a skill that will be instrumental in achieving the automated PDF Invoice Emails you've envisioned. Proficient in both Excel and Outlook, I can leverage VBA, VSTO add-in, or Power Automate flow to develop a solution tailored to your specific requirements. One of the core strengths my team and I bring is our commitment to delivering excellence. We don't just deliver a solution; rather, we ensure our clients can seamlessly integrate it into their environment. This means that once I provide you with the solution for your project, it will be easy for you to configure file paths, run schedules and launch the emails yourself without any hassle. Moreover, my cost-effective approach would ensure your budget is optimized without compromising on quality output. To me, client satisfaction matters above all else. Choose me for this project and together let's turn your vision into reality with an efficient automated invoice emailing system that saves you time and effort, giving you more room to focus on what truly matters - growing your business!
₹17,000 INR in 7 days
5.4
5.4

Hello, I have 4+ years of experience in Excel automation, VBA, Outlook workflows, and Office 365-based reporting solutions. I can build a simple one-click workflow that reads active invoice rows from Excel, pulls the recipient details, subject/body text, and PDF path, then automatically creates Outlook emails with the correct invoice attached, either sending them immediately or saving them as drafts based on a spreadsheet flag. I will also add a sent status with date-time stamping to prevent duplicate emails, test the process on current Outlook/Excel desktop versions, and provide clear setup notes so you can update paths and run it easily. Relevant Certifications: • Excel Basics for Data Analysis – IBM • Data Visualization and Dashboards with Excel and Cognos – IBM • Business Intelligence Essentials – IBM • Getting Started with Git and GitHub – IBM Regards, Talha Almas Data Scientist / Data Analyst / Full Stack Dev Relevant Skills: Excel, VBA, Outlook Automation, Office 365, Invoice Email Automation, PDF Attachments, Email Templates, Power Automate, Data Validation, Workflow Automation
₹5,000 INR in 1 day
3.4
3.4

This can be implemented as a simple one-click Excel to Outlook automation that reads each active row, attaches the correct invoice PDF, generates a personalized email, and either sends it or saves it to Drafts based on a spreadsheet flag. A very similar solution was recently developed for a large pharmaceutical company, where invoice and document emails were generated automatically from Excel while maintaining status tracking and duplicate-send prevention. The same approach can be adapted here with timestamp logging, validation checks, and straightforward configuration so you only need to update paths and click a button. The solution will be tested on current Outlook and Excel desktop versions and delivered ready for use in your environment. Looking forward to discussing the spreadsheet structure.
₹10,000 INR in 4 days
3.0
3.0

With over a decade of experience, I'm adept at delivering robust automation and business streamlining solutions, making projects like yours my bread and butter. I specialize in workflow automation, and my expertise spans to all Office 365 platforms, including VBA in Excel, VSTO add-ins, and Power Automate flows, the options you mentioned for this project. My talent for development intersects with my deep understanding of QA and testing creating products that are well-designed and free of glitches. Moreover, I'm an expert in data handling and manipulation as well as API integrations - two integral aspects for your project. For your final deliverable, I assure you a solution you can effortlessly update with folder paths included. When it is time to send those invoices out, you will see your vision come to life exactly. You'll have clean documented code that is both maintainable and scalable even as your business grows. This added to my proficiency with tools such as Playwright, Python (pandas/openpyxl), Shell scripting plus tools such as n8n • Make • Zapier • Zoho • GoHighLevel • HubSpot • Odoo among others which offers an infinite array of interconnected possibilities highlights why I am the perfect fit for your project
₹7,000 INR in 7 days
3.1
3.1

Hello, I can build a reliable invoice emailing solution using Power Automate, VBA, or Outlook automation based on your preferred Office 365 environment. The workflow will read invoice data from Excel, automatically attach the correct PDF, generate personalized emails, send them or save them as drafts based on a control flag, and update the spreadsheet with a sent timestamp to prevent duplicate deliveries. I have extensive experience with Excel automation, Outlook integration, Power Automate, and business process workflows. I will thoroughly test the solution on current Outlook and Excel desktop versions to ensure smooth, prompt-free operation and easy deployment. Best regards Sangeeta
₹7,000 INR in 3 days
0.5
0.5

Hi, I can build this solution for you using Excel VBA and Outlook Desktop, providing a simple one-click process to automatically send or save invoice emails directly from your spreadsheet. With extensive experience in Excel VBA automation, Outlook integration, and Office 365 workflows, I can deliver a reliable solution that will: ✔ Read recipient details, subject, body text, and PDF paths from Excel ✔ Generate personalized Outlook emails automatically ✔ Attach the correct invoice PDF for each customer ✔ Support both “Send Now” and “Save to Drafts” modes via a spreadsheet flag ✔ Timestamp and mark records as “Sent” to prevent duplicate emails ✔ Include error handling for missing files or invalid email addresses ✔ Be fully configurable through Excel without code changes The solution will be tested on current Outlook and Excel Desktop versions and delivered with clear instructions so you can simply update paths, click a button, and process invoices with confidence. I focus on creating user-friendly Excel automation tools that are reliable, maintainable, and easy to deploy in real business environments. I would be happy to discuss your spreadsheet structure and get started immediately. Best Regards, Tanmoy Mitra
₹12,500 INR in 7 days
0.0
0.0

As someone who has spent years working in AI and Cloud Data Engineering, I have amassed a broad array of skills that can be uniquely leveraged to solve your problem with precision and efficiency. This means that not only can I create a solution for you using the options you've specified - VBA in Excel, a VSTO add-in or Power Automate flow - but I can also explore other alternatives like using my knowledge of AI to improve the accuracy of email detection or build smarter subject lines based on customer patterns for example. Furthermore, my experience in building automation systems that handle real-time data is particularly useful in this scenario. Automating important processes like this one reduces manual effort, saves time and eliminates human error potential. My AI-driven workflows using tools like Azure Logic Apps, LLMs and intelligent bots makes me ideally suited to put together an automated solution that's tailored specifically to your needs. Beyond the technical skills however, I am committed to not just implementing solutions, but ensuring they deliver tangible value aligned with strategic objectives. As a result, if chosen for this project, not only will you get a perfectly functioning system that launches seamlessly but one that also helps drive measurable business outcomes in terms of increased operational efficiency, reduced costs and most importantly enabling smarter decision-making
₹9,000 INR in 10 days
0.0
0.0

Hi — I've built dozens of these Office automations; just new on Freelancer, so I'm pricing keenly. This one's clean and I can turn it around fast. I'll build a self-contained Excel VBA button: it loops your sheet rows, attaches the matching PDF, and sends each email via your desktop Outlook — one click, no security-prompt stalls. You update the folder paths, press the button, done. I'll test it on your Outlook/Excel before handoff. Quick Qs: (1) classic Microsoft 365 desktop Outlook or the new Outlook app? (2) rough batch size per run? (3) VBA button or Power Automate flow — I'd recommend VBA for the no-prompt, click-and-run feel. — Aakaash
₹6,000 INR in 2 days
0.0
0.0

Hi, I can build this as a small, testable Office automation rather than an open-ended mailer. My approach: - use Excel VBA + Outlook desktop, or Power Automate if your Microsoft 365 setup is better for your environment; - read only rows marked active/ready; - create the email from row fields: customer, recipient, subject/body and PDF path; - attach the matching PDF; - either send immediately or save as draft from a Send/Draft flag; - write a sent timestamp/status so reruns do not duplicate invoices; - log row-level failures if file path, recipient or attachment is missing. Bid: INR 9,500 / 3 days. Milestone: working file/flow, one test batch and setup notes. Assumptions: current desktop Excel/Outlook are available, PDF paths are reachable from the machine running the automation, and you can provide a sample workbook with 5-10 dummy rows. I will not need real client data before the milestone is funded; sample data is enough to build and test. Best, Carlos
₹9,500 INR in 3 days
0.0
0.0

Aurangabad, India
Member since Jun 24, 2026
$3000-5000 USD
$10-30 AUD
$15-25 USD / hour
$250-750 CAD
$250-750 USD
$30-250 USD
₹750-1250 INR / hour
$10-30 AUD
₹10000-20000 INR
$250-750 USD
$10-30 USD
$15-25 USD / hour
$250-750 USD
£20-250 GBP
$15-25 USD / hour
$250-750 USD
$15-25 USD / hour
$5000-10000 USD
₹12500-37500 INR
₹12500-37500 INR