Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Excel VBA macro to send email attachment from default email client

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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Excel VBA macro to send email attachment from default emailclient

On Apr 12, 10:42*am, wifigoo
wrote:
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.


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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Excel VBA macro to send email attachment from default email cl

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

" wrote:

On Apr 12, 10:42 am, wifigoo
wrote:
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.


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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
send wkbk as an email attachment with an email address copied from SueInAtl Excel Discussion (Misc queries) 0 May 21st 07 10:53 PM
Can't send attachment as Email from Excel 2007 Kristie Excel Discussion (Misc queries) 2 April 19th 07 10:56 PM
I can't send attachment from excel by email terry Excel Discussion (Misc queries) 0 September 28th 06 03:23 AM
cant send email attachment from excel DKT New Users to Excel 8 November 22nd 05 02:25 AM
In Excel I need to send a spreadsheet to email as attachment? 9g2REG3 Excel Programming 0 November 21st 05 06:11 PM


All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"