Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot reactivate workbook after sending email in VBA
Hi,
I've got code running/working that does its thing and then sends an email to a designated recipient. Of course, there is a warning message telling the user that a program is trying to send an email, and it asks for approval. That's fine, and the user simply clicks on Yes. The problem is the remaining code. I've got it set to re-activate the Excel workbook, but the code only works when Outlook is not open. When my Outlook is open, the active window switches from the Excel workbook to Outlook when the email is going out, then the warning message, and then it stays on Outlook. If I manually click back over to my Excel workbook, I can see the message box I have programmed in. This all works fine when Outlook is closed. Currently, my code is: Windows("PDF Portal.xls").Activate. Would this work if I used Workbook("PDF Portal.xls").Activate? Thanks for any help. Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending Workbook to an email address. | Excel Discussion (Misc queries) | |||
Sending an email from Excel attaching the workbook they are in | Excel Programming | |||
Sending an email on workbook save | Excel Programming | |||
Sending email WITHOUT attaching a workbook? | Excel Programming | |||
sending a workbook by email to multiple recipients | Excel Programming |