Sendkey alternative help

[Madmax]

Good AFternoon,

I am still shaky on VBA and i want to attempt something new that I dont know where to start. So I am going to describe the process.



1. Create a variable using fields + generic information+ fields
-Dim Message as string
-Message= "I am" & "[First name]" & " " & "[Last Name]"
I want to shift focus to notepad(it would be open already)
-Appactivate.notepad ???
Then put the message created into notepad. something like sendkey but sent it all. dont know the proper command or nothing. I have heard of type text but I dont know the syntax for it at all.

Thoughts?

-Madmax

[June7]

Google: Access VBA write text to notepad

Here is one http://www.vbforums.com/showthread.php?t=400591