Need help with use of clipboard in a macro

A

Al Jager

Can someone please help me??

I have stored an email address in a cell on various
workbooks.The workbooks are attached to an email via a
macro.

Is their a way to copy this address via the macro to the
clipboard and then to insert it in the email address??

Many thanks
Al
 
B

Bob Phillips

Al,

Is it necessary to do it this way?

Couldn't you pass the email address into the To field of the email object?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top