| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
email in XL XP
I have used Ron de Bruin's code to send about 50 emails with xls attachments
direct from excel. .Send to supress the warnings i replaced code above with code below: .Display Application.Wait (Now + TimeValue("0:00:01")) Application.SendKeys "%S" It works fine on 2000, but not on XP. Does anyone have any code that will suppress warnings within XP? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email in XL XP
Hi Newbe
SendKeys can give different results and is not reliable See if you can use CDO http://www.rondebruin.nl/mail/prevent.htm -- Regards Ron De Bruin http://www.rondebruin.nl "Newbie" wrote in message ... I have used Ron de Bruin's code to send about 50 emails with xls attachments direct from excel. .Send to supress the warnings i replaced code above with code below: .Display Application.Wait (Now + TimeValue("0:00:01")) Application.SendKeys "%S" It works fine on 2000, but not on XP. Does anyone have any code that will suppress warnings within XP? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
| send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
| Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel | |||
Linear Mode
