Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
Can't send attachment as Email from Excel 2007 | Excel Discussion (Misc queries) | |||
I can't send attachment from excel by email | Excel Discussion (Misc queries) | |||
cant send email attachment from excel | New Users to Excel | |||
In Excel I need to send a spreadsheet to email as attachment? | Excel Programming |