Anybody any good with VBA?
Author
Discussion

Andy SIBL

Original Poster:

144 posts

288 months

Thursday 2nd August 2007
quotequote all
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

annodomini2

6,974 posts

282 months

Thursday 2nd August 2007
quotequote all

AtomicRex

862 posts

258 months

Thursday 2nd August 2007
quotequote all
Are you wanting to use Outlook or Express??

It is quite easy to do, but you will require Outlook to be open otherwise you will be asked for security authorisation.

I dont have outlook on this pc only lotus notes but if you want me to stick some code together. Email me