Anybody any good with VBA?
Discussion
I'm trying to do something which I imagine is straight forward but I don't know the 1st thing about VBA.
I want to put a button in excel that when you click on it opens up a new e-mail prepopulated with addresses and a description in subject.
I know how to put the button in, it's the coding in the background I'm struggling with!
I know how to add a hyperlink to a cell normally that does what I want to do but unfortunately the maximum number of characters in the hyperlink box is too restrictive for my needs so I think VBA maybe the only other way.
Sorry if this sounds like a lot of waffle, but I know what I mean in my head at least!
All help greatly appreciated.
Andy
I want to put a button in excel that when you click on it opens up a new e-mail prepopulated with addresses and a description in subject.
I know how to put the button in, it's the coding in the background I'm struggling with!
I know how to add a hyperlink to a cell normally that does what I want to do but unfortunately the maximum number of characters in the hyperlink box is too restrictive for my needs so I think VBA maybe the only other way.
Sorry if this sounds like a lot of waffle, but I know what I mean in my head at least!
All help greatly appreciated.
Andy
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


