 Page [ 1 ]
|
|||
| Code Essentials Printer Friendly Version | |||
|
Beginner’s section on how to work in the VBA environment, how to work with functions and expressions – generally not specific to Outlook | ||
| Topic | |||
|
Creating a new type of paste special
I would like to create a macro that takes whatever has been copied to your clipboard, and pastes it into the body of an email (preferably where the cursor is at this moment) but with the spaces replaced with %20. Basically the problem is when i create a link as soon as it reaches a space, the hyperlink ends and i was trying to create a method of pasting a working hyperlink with spaces in it. I'm competent with VBA in excel but not in outlook so am stumped where to start. I assume i will have to have a .GetFromClipboard then modify the text and then a .Paste function Any Ideas? Sean Munday 06-Nov-2009 09:40 |
||
|
Page [ 1 ]
|
|||
| Post a new message to this topic. name email  |