How To Send a Table and a Chart in An Email via VBA Macro | I'm MS Excel Expert Tutorial | Day 36
HTML-код
- Опубликовано: 15 сен 2024
- This is Day 36 video of I'm MS Excel Expert tutorial series where we have discussed 1 topic as mentioned below:
1. How To Send a Table and a Chart in An Email Using Outlook via VBA Macro
Quick Summary of the tutorial:
We have started "I'm MS Excel Expert" tutorial series to help you to become an expert in MS Excel in a very short period of time. The tutorial "I'm MS Excel Expert" would become the game-changer for the beginners hence calling this tutorial perfect fit for the "MS Excel for Beginners" wouldn't be wrong.
We would love to take up any questions you may have at this point of time. Please post your queries/questions in the comment section along with your email address
Thank you so much.
Watch this space if you're willing to learn MS Excel quickly.
Please LIKE, COMMENT & SUBSCRIBE to the channel.
You can visit our Instagram page at: / finance_guy_nishant
Tags:
#Excel #LearnExcel #Beginners #excelforbeginner #excelforbeginners #MSExcel #ImMSExcelExpert #Tutorial #MSExcelForBeginners #OpenExcelUsingMacroVBA #ExcelFormulas #VLOOKUP #ConditionalFormating #HowToOpenAnExcelUsingMacroVba #Duplicate #ExcelFunctions #MicrosoftExcel Microsoft Excel #exceltutorial excel tutorial #FinanceGuyNishant Finance Guy Nishant #Macro #MacrosInExcel #VBAInExcel #excelTricks #excelshortcuts excel expert vba expert vba excel programming tutorial #VlookupMacro #SendEmail #HowToSendATableAndAChartInAnEmailUsingOutlookViaVBAExcel
Please post your email address. I will send the file.
how to take subject line from a specific cell suppose (2,19)
Thanks!
Really good and helps me in my day to day work all of your videos are..
That was so useful Nishant, thanks for sharing the video!
Glad it was helpful!
Awesome! Thank you!
Thanks for stopping by.
Thank you so much it working for display.
Some error if we remove the comment for send
Email is not sent
Can you pleade suggest here
Great tutorial, and it solved the problem I was having. Thanks very much. Do you have a further tutorial where the email created has a signature?
thanks for your work.
Glad it was helpful!
thanks much :) helped a lot
Glad, it was helpful!
Hello, thank you for this brilliant tutorial. For me after some adaptions it works really good ! But can you help how to include the Mail signature again ? The Code deletes the signature.
We need to add that. I think in my code that is not included. But while pasting in the body, you can manually add text which is the easiest way to add signatures than adding the specific code about it.
Nice sharing ❤️
Thank you.
Hey Nishant, thank you for your help however I am encountering a problem where it says run time error 287, for the set oWordDoc = oOutlook.. I am not able to solve it, thank you
I updated the references as specified, any idea why I am getting an "invalid or unqualified reference" after the .GetInspector command?
Usually, you should not get this error if you have selected the specified references. Please check the indentation or may be paste your code snippet here so that we all can review and help you with this, thanks.
How to point to particular sheet than the active sheet
Thank you🙏
This really helps me & works for me. I need to add tabel first and below that chart. I tried but couldn’t. I am a beginner for vba and please help to do that
Sorry for the late response, usually flipping the code should work. I mean, putting the table code first then chart should fix it, you need to tweak the code for this to happen, thanks.
How to left shift this table in outlook?
Hello Nishant, liked your content, great work. I needed your help for it says that it is not defined (Dim oOutlookInspect As Outlook.Inspector) as error it says user defined type not defined. could you please help me on that?
Check the "Reference" on VBA page. Make sure you check the appropriate references there, it should work. Thanks.
Hi Nishant, thanks for the video. I have selected the entire table and gave the name. It worked fine. Now I want to change the range as the number of rows got increased. I tried selecting new range and giving the name. But the macro is frozen for the initially selected range. How can I change the name of the new table/range. Thanks in advance.
You can change the name of the table from the Excel "Name Range" piece. Another way is to call up the range via VBA so in this way you do not have to call the table name, this may require tweaking the code though, thanks.
It worked great initially and has worked only sporadically since then because VBA drops the run time error 5097 on the wordrng1.paste portion of the code. I cant seem to figure it out. Any solution to this ?
It will be difficult to comment on the solutions until I see the solution, can you please paste your code snippet here. Thanks.
I'm getting this error "248, this command is not available because no document is open " at Set oWordRng = oWordDoc.Application.ActiveDocument.Content
muito obrigado.
Muito obrigado por seus trabalhos amáveis.
can you please explain how to add more than 3 person as CC in Email
Dim OLInspect As Outlook.Inspector is not working for me. Its Compile Error: User- Defined type not defined. Any solution for that?
Usually, it is due to indentation issue. Please verify that. It should work.
Hey, tutorial was very helpfull, but when i change .display to .save I have error in this line Set oWordRng = oworddoc.Application.ActiveDocument.Content Can you help whats is wrong?
It will be difficult to comment on the solutions until I see the solution, can you please paste your code snippet here. Thanks.
Hi thanks for making this video
When I run the code
I get an error where owordrng variable is not defined could you please help me with this
Apologies for the late reply. Can you please check your references in the tools options please.
Hi, I worked with your vba coding for only table and I am geting error wordrng not set, can u help me with this
It will be difficult to comment on the solutions until I see the solution, can you please paste your code snippet here. Thanks.
Hi sir , please make video for copy pivot table and send email using VBA
As soon as possible
Any idea why I am getting an "invalid or unqualified reference" after the .GetInspector command?
And please if possible to get only Table excluding Chart one
You can deactivate the chart related code and then in that case you have only tables.
Hi thanks for your video
Can we auto send excel table by gmail? and how to do it? Thanks
Thanks for stopping by. The code is written for Outlook. It will not work for Gmail. Thanks.
Can you please share the Excel file Or VBA code
Apologies for the late reply. Please share your email address. I'll forward the file.
@@financeguynishant17 can you share it with me?
Please post your email address. I will send.
From where I can copy this code....
Put your email address here, I will send the code. Else you have to type it out from the video only, thanks.
How do I send the table with out the chart?
Remove the code related to charts. Have only Table related code, it should work, thanks.
U didnt mention how to add the signature in the end of the email. Another problem is u dont refer the tables using the cells references.
Good catch friend, I will be mindful about this in my upcoming videos. Thanks.
Bro how do I contact you.?
Nishantggn1@gmail.com
Please send this macro
Please share the email address. I will share, thanks.
Hello Nishant, Thanks for posting this video . I'm getting error on oWordDoc1 = oOutlookInspect.WordEditor. could you please help
It will be difficult to comment on the solutions until I see the solution, can you please paste your code snippet here. Thanks.
Hi Sir, I have issue with same code, while I am running it during screen locked PC. copy mothed doesn't work. Please support
You need to make the visible = False. This way it should work, thanks.