|
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 11:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com