Send emails directly from Excel using ChatGPT

Поділитися
Вставка
  • Опубліковано 31 тра 2023
  • In this tutorial, learn how to automate the process of saving an Excel report as a PDF file and sending it via email using VBA macros. The macro saves the report in the 'Monthly Sales Report' tab as a PDF file in the same folder as the Excel file. It then reads email addresses and subject lines from Sheet1 and sends the PDF report as an attachment using Outlook. Streamline your reporting workflow with this step-by-step guide!
  • Навчання та стиль

КОМЕНТАРІ • 3

  • @petermelling798
    @petermelling798 Рік тому

    Hiya Ali, let us know what you are working on, aye!

    • @HashAliNZ
      @HashAliNZ  Рік тому

      Hey Peter! Sorry I haven't got to your Lambda requests yet - it's a big topic that's hard to figure out how to start. It'll be in the medium-term plan since Lambdas are quite advanced.
      Coming soon:
      - Autotext in Chrome
      - Attendance Questions for Teachers
      - Basics of the Query Function
      - Spreadsheet horror stories
      I've also got a course in the works for absolute beginners. If I can get more money coming in, that'll allow me to ramp up the whole system. Right now, I'm a solo creator so all the ideas, writing, scripting, filming (and everything that comes with it!), editing, pre- and post-publishing is all me. And that's just one of my jobs!
      Thanks so much for being a huge supporter of me and my channel. You're awesome, Peter!
      Just out of curiosity, do we know each other in real life? What keeps you sticking around?
      Thanks!
      - Hash

    • @petermelling798
      @petermelling798 Рік тому

      @@HashAliNZ Your UA-cam content and my interest in hacking / tinkering to improve education apps and be part of a team. I'm into using nocode spreadsheets to make an educator daybook that automated matching lessons day with curriculum and resources. LAMBDA is important to lock in previous data if there is a timetable change for example.