ChatGPT and Excel to Automate Sending Emails

Start learning ChatGPT and do not get left behind: www.amazon.com/shop/datavisua...
This is Excel automation I wanted to do for a long time - send emails directly from excel as PDF files, and now ChatGPT has shown me how to do it!
📇The prompt used:
Write a VBA Macro that will
-Save the Tab specified in cell B1 in Sheet1 as PDF file in the same folder the excel file is located
-Use B3 cell in Sheet1 as Email Title and send the PDF to the email adress in B2 cell in Sheet1
Check the Playlist with ChatGPT and Excel examples and prompts:
✔️ How To Use ChatGPT: shorturl.at/empAD
🏁 Subscribe and click the notifications 🔔 bell so you never miss a video!
☕ Buy me a coffee: www.buymeacoffee.com/visualizedd
📊 Subscribe: bit.ly/3a9uqcr
🛒 Check out some merch: bit.ly/3fhtiVL
🧰 My SEO "Secret Tool": vidiq.com?afmc=62f
chatgpt and excel,chat gpt and excel,chatgpt excel,chatgpt excel vba,excel chatgpt,chatgpt and excel to automate,chatgpt excel automation,chatgpt and excel to automate reporting,how to use chatgpt,how to use chatgpt and excel,chatgpt prompts,chatgpt,chat gpt,how to use chat gpt,how to use chat gpt for automation,chat gpt automation,how to use chatgpt for automation,how to chat gpt,chatgpt automation,how to use chatgpt with excel,excel macros,automation
📧 Email for Business Inquiries: [e-mail]
© 2023 Data Visualized // All rights reserved.
#chatgpt #excel #ai

[@datavisualized7214]

What are some Tips&Tricks you know to write better prompts for ChatGPT?

[@AngieARTmanga]

Amazing step by step help a lot😊😊

[@datavisualized7214]

Thank you

[@laviniaasofiei9054]

Amazing stuff!

[@datavisualized7214]

Thank you!

[@richardwilde1348]

The sound on your videos sounds a bit quiet. Compare to other videos, think the volume is too low?

[@datavisualized7214]

Yes, some of my videos are recorded with the microphone on the phone

[@avinashyt1]

Can a table be copied in the outlook using this macro?

[@datavisualized7214]

Yes it can. What is the specific situation you are trying to do?

[@avinashyt1]

Actually i have to send tables (pasted in body) to different mails with cc as well.

[@Gamer-qm9ol]

I need to do this with a list of emails can you help me i will pay

[@Cognizantcloud001]

Yes

[@davidsilver2558]

This was great. I have a process that I would like to optimize but I would have to explain it. Can I reach you at an email address?

[@datavisualized7214]

Yes sure, just send me an email and I will look at it

[@JustinWiggins]

You lost me when you said Edison invented the lightbulb

[@datavisualized7214]

Tesla, I meant Tesla..