| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
email macro
Hi
I want to create a macro that will mail a range of cells in the body of an email, I use Outlook express, is this possible? Thanks in advance Alannah |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email macro
Se Ron's pages:
http://www.rondebruin.nl/sendmail.htm "Alannah Schuman" <Alannah Schuman @discussions.microsoft.com wrote in message ... Hi I want to create a macro that will mail a range of cells in the body of an email, I use Outlook express, is this possible? Thanks in advance Alannah |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email macro
Thanks Cory
I have tried Ron's code but met error '429' Activex component-- can't create object. The problem in the vb code is 'Set OutApp = CreateObject("Outlook.Application")'. Thats why i thought using Outlook Express might be a problem. Do you know anything about this? Thanks Alannah |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email macro
Did you see this:
http://www.rondebruin.nl/mail/oebody.htm Corey.... "Alannah Schuman" wrote in message ... Thanks Cory I have tried Ron's code but met error '429' Activex component-- can't create object. The problem in the vb code is 'Set OutApp = CreateObject("Outlook.Application")'. Thats why i thought using Outlook Express might be a problem. Do you know anything about this? Thanks Alannah |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email macro
Thanks Corey i had missed that bit. i have now made some code using send keys
that works! "Corey" wrote: Did you see this: http://www.rondebruin.nl/mail/oebody.htm Corey.... "Alannah Schuman" wrote in message ... Thanks Cory I have tried Ron's code but met error '429' Activex component-- can't create object. The problem in the vb code is 'Set OutApp = CreateObject("Outlook.Application")'. Thats why i thought using Outlook Express might be a problem. Do you know anything about this? Thanks Alannah |
| 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 | |||
| Email using a macro | Excel Programming | |||
| Excel VBA macro to send email attachment from default email client | Excel Programming | |||
| How do I create an email macro to auto fill the email? | Excel Discussion (Misc queries) | |||
| email macro | Excel Programming | |||
Hybrid Mode
