ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   sendkeys sends every other letter Excel 2007 to Outlook 2007 (https://www.excelbanter.com/excel-programming/439545-sendkeys-sends-every-other-letter-excel-2007-outlook-2007-a.html)

BenF

sendkeys sends every other letter Excel 2007 to Outlook 2007
 
I am running a macro that uses Sendkeys to send text from an Excel cell to
the body of an email in Outlook. Worked fine in Office 2003 but since
upgrade to 2007 it now only sends every other letter. So, for example, if the
value in the cell was "abcdefghij", then Outlook would only receive "acegi".
Any ideas?

Peter T

sendkeys sends every other letter Excel 2007 to Outlook 2007
 
You didn't post any code so it's not possible to answer your question. That
said, SendKeys is notoriously unreliable; hard to be sure without knowing
what you are doing but most likely you can accomplish your objective by
automating Outlook.

Regards,
Peter T

"BenF" wrote in message
...
I am running a macro that uses Sendkeys to send text from an Excel cell to
the body of an email in Outlook. Worked fine in Office 2003 but since
upgrade to 2007 it now only sends every other letter. So, for example, if
the
value in the cell was "abcdefghij", then Outlook would only receive
"acegi".
Any ideas?





All times are GMT +1. The time now is 01:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com