Excel VBA macro to send email attachment from default email client

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wifigoo - 12 Apr 2008 10:42 GMT

Hello,

I would need help to create a VBA macro that will send an email attachment
(a .zip file which contains an encrypted Workbook) using the default email
client (not necessarily Outlook). I would need to be able to specify the
"To:" email address and the "Subject:". I don't need to specify any message
body, but this might be helpful to others.

Thank you so much for your help.
Kindest regards,
Olivier.

Reply to this Message

simmo13@gmail.com - 12 Apr 2008 11:37 GMT

On Apr 12, 10:42 am, wifigoo <wifi...@discussions.microsoft.com>
wrote:

> Hello,
>
[quoted text clipped - 7 lines]
> Kindest regards,
> Olivier.

Oliver,

You need to use a windows API call - most people I know use a
"cookbook" approach to these. John Walkenbach has a good page which
demonstrates the API call: http://www.j-walk.com/SS/excel/tips/tip86.htm

or try Ron De Bruin's site: http://www.rondebruin.nl/

Hope this helps,

Alex

Reply to this Message

wifigoo - 12 Apr 2008 15:54 GMT

Thanks Alex.

I had come across the tips provided by Walkenback and Ron de Bruin.
Unfortunately, the former uses a mailto URL which doesn't allow any
attachments and the later requires an smtp server to be specified. I wish to
send a survey to numerous people in the form of a spreadsheet. I would like
people to be able to respond and send the form back by the click of a button.
I do not know in advance which email clients or smtp servers are being used.

Thank you for trying to help me out.
Have a great day.
Olivier

> On Apr 12, 10:42 am, wifigoo <wifi...@discussions.microsoft.com>
> wrote:
[quoted text clipped - 21 lines]
>
> Alex

Reply to this Message