SendKeys command not focusing on the correct open program

M

mjwillyone

Friends,

I am using the following programming in a macro. Working with MS
outlook the SendKeys "%s", True" found at the bottom of the "code" will
send the email. However, I want to use Eudora Pro rather than Outlook
and I want to save the e-mails rather then send them. To save these
"personalized" e-mails, I need to use Sendkeys "^s". The problem, this
is the same Sendkeys command that is used to save the current open
Excel spreadsheet . . . not what I want to do.

How can I focus control on the open Eudora software when attempting to
save the e-mail, then move control back again to Excel after the e-mail
save has taken place?

I have used the Sendkeysto command in WinBatch to select the open
software in which the command will take place, but do not see this
command in VB.

For Each cell In
Columns("e").Cells.SpecialCells(xlCellTypeConstants)
If cell.Value Like "*@*" Then
Recipient = cell.Value
Subj = "Funds Sent Today"
Msg = "Dear " & cell.Offset(0, -4).Value & "%0A"
Msg = Msg & "%0A" & "This is just a quick e-mail to let you
know that today the following amount was sent to your bank account: " &
"%0A"
Msg = Msg & "%0A"
Msg = Msg & "$" & cell.Offset(0, -3).Value & "%0A"
Msg = Msg & "%0A" & "Bookkeeper"
HLink = "mailto:" & Recipient & "?"
HLink = HLink & "subject=" & Subj & "&"
HLink = HLink & "body=" & Msg
ActiveWorkbook.FollowHyperlink (HLink)
Application.Wait (Now + TimeValue("0:00:3"))
SendKeys "%s", True
End If
Next


Is there a way to change add lines around the SendKeys line??

(this line would focus control on the Eudora software)
SendKeys "%s", True
(this line would focus control back on the open Excel software)

Thanks,
Mike
 

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

Top