Need help with use of clipboard in a macro

  • Thread starter Thread starter Al Jager
  • Start date Start date
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
 
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)
 
Back
Top