Sending Workbooks via Email

[VBA Dabbler]

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

[BAC]

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

[Ron de Bruin]

Hi

See my site for example code
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"VBA Dabbler" <VBADabbler@discussions.microsoft.com> wrote in message news:E1840A82-7097-45F2-870E-F20664EA556B@microsoft.com...
> 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

[VBA Dabbler]

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" <VBADabbler@discussions.microsoft.com> wrote in message news:E1840A82-7097-45F2-870E-F20664EA556B@microsoft.com...
> > 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
>
>
>

[Ron de Bruin]

You are welcome

--
Regards Ron de Bruin
http://www.rondebruin.nl


"VBA Dabbler" <VBADabbler@discussions.microsoft.com> wrote in message news:2A3393B9-5F8A-4484-94AC-369580208250@microsoft.com...
> 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" <VBADabbler@discussions.microsoft.com> wrote in message news:E1840A82-7097-45F2-870E-F20664EA556B@microsoft.com...
>> > 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
>>
>>
>>