Thank you so much for this video. So clear and easy to follow. I was losing the will with excel.
@elzbietadrogomirecka3513 жыл бұрын
Fantastic tutorial - clear, informative and very very helpful. Thank you!
@linawinny37434 жыл бұрын
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.
@devendranpillaiperumal11784 жыл бұрын
This thing works like magic. Thank you very much
@charliearmour16285 ай бұрын
Excellent, thank you.
@sorinm2212 жыл бұрын
This is an awesome tutorial! Life saver.
@alvaromartinez7584 жыл бұрын
Can we add the signature after pasting the picture??
@rubyjanebalancio20574 жыл бұрын
This is very helpful! Thank you
@jiturane82324 жыл бұрын
Can we add signature after paste body mail ??
@zh80784 жыл бұрын
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?
@Abhishekyadav-mo6py2 жыл бұрын
Please insert .display
@GT_7553 жыл бұрын
The "oWdEditor" should be "oWordDoc", i think the author is great but he is human. :)
@wannabe_quant68524 жыл бұрын
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. :)
@frantzbernier3792 Жыл бұрын
Thank you, it works fine. Is it possible to add/keep a default signature?
@petardzopalic32208 ай бұрын
HI thank you for tutorial. how to paste not like a picture , I would like to paste it like range .
@dennisprada9452 жыл бұрын
Very helpful tutorial! How can I do this with multiple range?
@asystman4 жыл бұрын
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.
@SigmaCoding4 жыл бұрын
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.
@Alucard08313 жыл бұрын
Any way I can paste the copied range between bodies of text?
@Gunanimbuzz3 жыл бұрын
Thank you so much
@ryanyoung86164 жыл бұрын
Hi thankyou this is very helpful! Also, mate can you create a video that adds an existing signature after the copied cell range?
@SigmaCoding4 жыл бұрын
Yeah I can look into that.
@SQ-kk8qt2 жыл бұрын
Thanks! Is that possible to add a signature at the bottom of the email?
@nurfarzanaosman30723 жыл бұрын
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.
@nurfarzanaosman30723 жыл бұрын
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.
@jacobruiz16713 жыл бұрын
The image pastes below my signature, how do I make it so the image pastes above the signature in the body?
@wesleyjiang19792 жыл бұрын
how to adjust the space between the body text and the picture?
@hemantgull2 жыл бұрын
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)
@michellelee84814 жыл бұрын
Do you have a macro code for sending email from Excel to IBM Notes instead?
@fahrrent Жыл бұрын
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?😊
@danielwagner16963 жыл бұрын
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.
@trevormcintosh5824 жыл бұрын
Hi, an extra code that can be added to make the picture wider, so it takes up more of the mail window?
@captainka674 жыл бұрын
yes, this would be handy.
@ianlafferty2264 Жыл бұрын
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?
@smartjudy Жыл бұрын
Ian I am coming across the same thing. Did you ever figure it out?
@ianlafferty2264 Жыл бұрын
@@smartjudy no😕 I ended up going down a different route using Power Automate rather than correcting the VBA
@cgfreed34 жыл бұрын
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
@SigmaCoding4 жыл бұрын
Did you make sure to use the "Set" keyword on the line where you specify the Excel Range?
@cgfreed34 жыл бұрын
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?
@j.dasilva45672 жыл бұрын
U forgot to mention how to add signature at the end of the email.
@Dookdig1 Жыл бұрын
If i need to add another part , how can i add it
@user-on4je5vg3c4 жыл бұрын
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?
@SigmaCoding4 жыл бұрын
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
@user-on4je5vg3c4 жыл бұрын
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
@SigmaCoding4 жыл бұрын
@@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?
@marcellribeiro84633 жыл бұрын
Congrats! Great Video. Is it possible to past as "table" in outlook instead of picture? If yes, could you please say the code?
@davidferrick2 жыл бұрын
I know this is an old question but change wdPasteMetafilePicture to wdPasteHTML
@billcollier65658 ай бұрын
Bless you for asking and answering this question!!! Finally the answer I have been looking for!!