Copying info to the clipboard in code

  • Thread starter Thread starter -Michelle-
  • Start date Start date
M

-Michelle-

Hi

Using A2003

I want to do what I think is very simple but cannot seem to do it.

In short: the users have a report which they can email. I want to be able
to essentially "copy" the email address to the clipboard, so that when they
open their email program, they just paste it in. Clearly, I want to do this
in code, not using the menu copy/paste option :)

TIA
Michelle
 
Hi Allen

No. I've done the open outlook with sendobject but was unable to attach the
file automatically. The problem was at first needing to save the file first
(I thought) before you can attach it, but I couldn't work out how to attach
it. These reports are created all the time, and it isn't something you
want to store. Just attach and send.

Is there a way to automatically attach a .pdf file to the email without
having to save the file first would be wonderful? Otherwise the client just
wants to have the email address in clipboard and they wish to just paste it
themselves. Not your normal scenario.

Any other suggestions?

TIA
Michelle
 
Ah, you want to attach a file. SendObject won't do that for you, but if you
set the EditMessage argument to Yes, you can let the user attach the file
before sending. That still seems better to me than:
Application.FollowHyperlink mailto:[email protected]

For alternatives, see Tony Toews' email FAQ at:
http://www.granite.ab.ca/accsmstr.htm

To answer your original question, this code will allow you to stuff
something into the clipboard:
http://www.mvps.org/access/api/api0049.htm
 
Allen thanks so much for your reply. Stuffing into the clipboard worked
well. Thanks again.
 
Back
Top