great code. i am encountering an error at the "get word inspector" portion of the code and receiving a run time error 287 application defined or object defined error. i checked every line of code against yours and cant seem to find the issue. i made sure to add the relevant references; is it possible my employer has some functionality restrictions with outlook?
hey, I have a quick query. Say we have selected the WordEditor, then specified a range by getting the ActiveDocument's Content. The oWrdRng.Collapse Direction:=wdCollapseEnd bit is equivalent to what if we did the same thing either with the keyboard or the mouse? For example .Paragraphs.Add, I presume is similar to hitting enter so, to add to this .InsertBreak corresponds to what action? we have just added a paragraph why dont we just paste there? Lastly, why do you use the "oWdEditor" variable-object although we have already specified the word editor via oLookIns.WordEditor hence use the oWrdDoc instead of oWdEditor? Sorry for the lengthy queries and thank you for the video. :)
Is there any reason why the .Display option works perfectly well, whereas in the .Send option only the " " part appears in the email? The part which has been copied from excel is missing completely.
I think it has something to do with the fact that when you call the "Display" method it returns an Inspector object. The inspector object is what we use to access the "WordEditor" property which is used to paste the content. What you could do, if you don't want to display it, is to use the "GetInspector" property to return the MailItem Inspector.
Hi, thanks a lot for this video. really helpful. Have a q when I want to copy larger ranges that might need landscape format in a word or outlook. Cause when I did that with above code and used "SetExcRng = Selection.SpecialCells(xlCellTypeVisible) it cuts off half of the pasted picture). Is there a solution to this? Thanks in advance.
Hi Thank you very much. It works. But why its not display the right range set as in the code? 2 column at the end is not displaying in the outlook. Hope u can help.
Good Informative tutorial, Whenever i copy and paste the excel range with hyper links to outlook, they shorten ( Example Original : \\Server\folder1 Changed : folder1, which will not function once clicked )Please help ( Body format Richformat text)
Hi this has been incredibly helpful!! I have a question for the single subroutine. Why doesn’t this populate the body of my email? The “here are all the ranges...” shows up but not the range that’s supposed to be copied from excel. I don’t have a problem when the range is specified in the multi subroutine
Sigma Coding thanks a lot! I think the github code is different to the video but it’s all working now. Do you have a video where it shows how a default signature can be added after the range is pasted?
For some reason I can seem to get my range area to copy into outlook? Everything else seems to work, the range highlights when the module runs so I assume it’s “copying” just doesn’t seem to paste to outlook 😢 any suggestions?
Hi! Thanks for the video, it’s been really helpful but I have a question: is this possible to copy excel table with an option of editing it within the outlook?
Like once they paste it in Outlook you can just edit it as a normal table? That is possible you would just change this line: oWrdRng.PasteSpecial DataType:=wdPasteMetafilePicture To this: oWrdRng.PasteSpecial DataType:=wdPasteShape or this: oWrdRng.Paste
Sigma Coding yup, thanks a lot for help! Btw, do you have kind of a forum or website where the user can ask the questions? Coz now I’m facing the problem with importing 2 different tables to Outlook and inserting the text between them...may be you or your team could somehow help. Thanks
@@user-on4je5vg3c One man show here, so I'm the one who has to answer all the questions. It's been getting progressively harder to answer questions as the channel has grown in size, but it's interesting to see how people approach particular tasks. If you want, you can send your code to coding.sigma@gmail.com, and I can take a look at it. It sounds like the selection might be off slightly. I've never considered having a forum to ask questions, do you happen to know of a good platform that offers that service?
Fantastic tutorial - clear, informative and very very helpful.
Thank you!
Thank you so much for this video. So clear and easy to follow. I was losing the will with excel.
Hi, thanks to this one which I need now. but what is owdEditor. is it variable? because I get the debug that variable not define.
This thing works like magic. Thank you very much
This is an awesome tutorial! Life saver.
Can we add the signature after pasting the picture??
great code. i am encountering an error at the "get word inspector" portion of the code and receiving a run time error 287 application defined or object defined error. i checked every line of code against yours and cant seem to find the issue. i made sure to add the relevant references; is it possible my employer has some functionality restrictions with outlook?
Please insert .display
This is very helpful! Thank you
Excellent, thank you.
hey, I have a quick query. Say we have selected the WordEditor, then specified a range by getting the ActiveDocument's Content. The oWrdRng.Collapse Direction:=wdCollapseEnd bit is equivalent to what if we did the same thing either with the keyboard or the mouse? For example .Paragraphs.Add, I presume is similar to hitting enter so, to add to this .InsertBreak corresponds to what action?
we have just added a paragraph why dont we just paste there?
Lastly, why do you use the "oWdEditor" variable-object although we have already specified the word editor via oLookIns.WordEditor hence use the oWrdDoc instead of oWdEditor?
Sorry for the lengthy queries and thank you for the video. :)
Can we add signature after paste body mail ??
Is there any reason why the .Display option works perfectly well, whereas in the .Send option only the " " part appears in the email? The part which has been copied from excel is missing completely.
I think it has something to do with the fact that when you call the "Display" method it returns an Inspector object. The inspector object is what we use to access the "WordEditor" property which is used to paste the content. What you could do, if you don't want to display it, is to use the "GetInspector" property to return the MailItem Inspector.
Any way I can paste the copied range between bodies of text?
HI thank you for tutorial.
how to paste not like a picture , I would like to paste it like range .
Hi, thanks a lot for this video. really helpful. Have a q when I want to copy larger ranges that might need landscape format in a word or outlook. Cause when I did that with above code and used "SetExcRng = Selection.SpecialCells(xlCellTypeVisible) it cuts off half of the pasted picture). Is there a solution to this? Thanks in advance.
Hi, i have a minor problem with your codes,
Its not automatically pasting on outlook, i have press ctrl +v to paste is on email,
Any solution?😊
The image pastes below my signature, how do I make it so the image pastes above the signature in the body?
Thank you, it works fine. Is it possible to add/keep a default signature?
Thanks! Is that possible to add a signature at the bottom of the email?
Do you have a macro code for sending email from Excel to IBM Notes instead?
Hi Thank you very much. It works. But why its not display the right range set as in the code? 2 column at the end is not displaying in the outlook. Hope u can help.
i use this code oWrdRng.Paste instead. It display all column i wanted to paste. But i don't want it to be display as normal table.
Hi, an extra code that can be added to make the picture wider, so it takes up more of the mail window?
yes, this would be handy.
how to adjust the space between the body text and the picture?
Good Informative tutorial, Whenever i copy and paste the excel range with hyper links to outlook, they shorten ( Example Original : \\Server\folder1 Changed : folder1, which will not function once clicked )Please help ( Body format Richformat text)
The "oWdEditor" should be "oWordDoc", i think the author is great but he is human. :)
If i need to add another part , how can i add it
Hi this has been incredibly helpful!! I have a question for the single subroutine. Why doesn’t this populate the body of my email? The “here are all the ranges...” shows up but not the range that’s supposed to be copied from excel. I don’t have a problem when the range is specified in the multi subroutine
Did you make sure to use the "Set" keyword on the line where you specify the Excel Range?
Sigma Coding thanks a lot! I think the github code is different to the video but it’s all working now. Do you have a video where it shows how a default signature can be added after the range is pasted?
For some reason I can seem to get my range area to copy into outlook? Everything else seems to work, the range highlights when the module runs so I assume it’s “copying” just doesn’t seem to paste to outlook 😢 any suggestions?
Ian I am coming across the same thing. Did you ever figure it out?
@@smartjudy no😕 I ended up going down a different route using Power Automate rather than correcting the VBA
Very helpful tutorial! How can I do this with multiple range?
Hi thankyou this is very helpful! Also, mate can you create a video that adds an existing signature after the copied cell range?
Yeah I can look into that.
Thank you so much
Hi! Thanks for the video, it’s been really helpful but I have a question: is this possible to copy excel table with an option of editing it within the outlook?
Like once they paste it in Outlook you can just edit it as a normal table? That is possible you would just change this line:
oWrdRng.PasteSpecial DataType:=wdPasteMetafilePicture
To this:
oWrdRng.PasteSpecial DataType:=wdPasteShape
or this:
oWrdRng.Paste
Sigma Coding yup, thanks a lot for help! Btw, do you have kind of a forum or website where the user can ask the questions? Coz now I’m facing the problem with importing 2 different tables to Outlook and inserting the text between them...may be you or your team could somehow help. Thanks
@@user-on4je5vg3c One man show here, so I'm the one who has to answer all the questions. It's been getting progressively harder to answer questions as the channel has grown in size, but it's interesting to see how people approach particular tasks. If you want, you can send your code to coding.sigma@gmail.com, and I can take a look at it. It sounds like the selection might be off slightly.
I've never considered having a forum to ask questions, do you happen to know of a good platform that offers that service?
Wdpastemetafilepicture command is not working
How can you make it work as a button
Congrats! Great Video. Is it possible to past as "table" in outlook instead of picture? If yes, could you please say the code?
I know this is an old question but change wdPasteMetafilePicture to wdPasteHTML
Bless you for asking and answering this question!!! Finally the answer I have been looking for!!
U forgot to mention how to add signature at the end of the email.