| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending Workbooks via Email
Does anyone know how to (using VBA) email a workbook? I want to populate
recipients, message, subject, etc. Is there a way to pull up the "global address list" from Outlook for recipient selection? Regards, VBA Dabbler |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sending Workbooks via Email
Application.Dialogs(xlDialogSendMail).Show Just a suggestion..I got this code using the macro recorder. If you're just learning VBA it's really a great place to start. BAC "VBA Dabbler" wrote: Does anyone know how to (using VBA) email a workbook? I want to populate recipients, message, subject, etc. Is there a way to pull up the "global address list" from Outlook for recipient selection? Regards, VBA Dabbler |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sending Workbooks via Email
Hi
See my site for example code http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "VBA Dabbler" wrote in message ... Does anyone know how to (using VBA) email a workbook? I want to populate recipients, message, subject, etc. Is there a way to pull up the "global address list" from Outlook for recipient selection? Regards, VBA Dabbler |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sending Workbooks via Email
Ron,
Thanks for the referral to your website - it was very helpful. Regards, VBA Dabbler "Ron de Bruin" wrote: Hi See my site for example code http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "VBA Dabbler" wrote in message ... Does anyone know how to (using VBA) email a workbook? I want to populate recipients, message, subject, etc. Is there a way to pull up the "global address list" from Outlook for recipient selection? Regards, VBA Dabbler |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sending Workbooks via Email
You are welcome
-- Regards Ron de Bruin http://www.rondebruin.nl "VBA Dabbler" wrote in message ... Ron, Thanks for the referral to your website - it was very helpful. Regards, VBA Dabbler "Ron de Bruin" wrote: Hi See my site for example code http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "VBA Dabbler" wrote in message ... Does anyone know how to (using VBA) email a workbook? I want to populate recipients, message, subject, etc. Is there a way to pull up the "global address list" from Outlook for recipient selection? Regards, VBA Dabbler |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sending a Spreadsheet as an Email Attachment vs. Imbedded in Email | Excel Discussion (Misc queries) | |||
| Email sending | Excel Discussion (Misc queries) | |||
| Sending an email | Excel Programming | |||
| Sending an email to more than one person. | Excel Programming | |||
| HELP sending email from Excel | Excel Programming | |||
![VBA Dabbler[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
