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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Macro: VBA code to move/forward email based on subjects and attachments 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Pasting a range to a single cell 0
Macro to restore previous content of clipboard 3
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0

Top