I have been trying to create a macro in outlook which copies the previously selected part of an email and pastes it onto an existing word template. The code I have created gives me "object variable or with block variable not set"
Which object do I need to set?HTML Code:
Which selection are you referring to? Outlook or Word? So, you have to specify.
Please Login or Register to view this content.
David
(*) Reputation points appreciated.
Thanks Tinbendr - I have added objWord to that last line and it now works in that it pastes the clipboard contents. However, now I can't get it to copy to clipboard, I get "Object doesn't support this property or method" error on. Researching other blogs, it seems I need to use DataObject but I can't find how to define this. Should I post this as a separate question or keep it altogether?HTML Code:
Last edited by bensox; 02-14-2014 at 05:21 AM.
Here is an excellent article about clipboard in VBA.
After some searching, apparently you can't get the selected text in a preview window. However, I was able to get selected text in activewindow.
You'll have to have the MSForms reference set in Excel. to use DataObj.
Please Login or Register to view this content.
Tinbendr, I get "Compile error: Expected variable or procedure, not project" atwhen I run the code you provided. I read the article you point to and also http://http://www.excelforum.com/exc...ataobject.html, which helped me find that I did indeed have MSForms listed. But adding an explicit reference didn't change anything. Appreciate your help, I think we're very near the solution now.Please Login or Register to view this content.
I thought you might. /:|
Outlook certainly isn't my forte`.
This was the only way i could get it to work.
Please Login or Register to view this content.
Yes, adding your extra code to it worked, however I will have to play around a bit more as the email messages in questions have the text split up in a table style format and the macro only copies the first part of that which is selected. Thank you for getting me this far though!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks