Copy data to buffer 1

[PhoenixDon]

My users have a requirement to extract certain data elements and email them to another out of state office. They have been typing them, but I would like to simplify this to a button click, then paste in the email. My question, how can I build a multi-line formatted string, and copy it to the buffer, so it can be pasted?

myStr = [Course Name].value
CopyToBuffer(myStr)

Thanks,
Don in Phoenix

 

[Remou]

What you need is SendObject.

[tt]strText = "Text" & "More Text" & vbCrLf & "Text Here"
DoCmd.SendObject acSendNoObject, , , "ToHere", , , "Re: Data", strText, True[/tt]

 

[AccessGuruCarl]

dcrowe99,

I'm assuming your trying to copy this to the clipboard.
You need to use API functions...

Follow this link, it should do what you need.

http://www.mvps.org/access/api/api0049.htm

AccessGuruCarl
Programmers helping programmers
you can't find a better site.