| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending a selection by email
I cannot find any VBA code to allow me to send a Selected Range as
part of the body of an email. I can do this easily by first selecting the range; and the use MSExcel menu "File-Sent To-Mail Recipient" add email address and subject and then press "Send-Selection". I can send a whole workbook using VBA Code:- "ActiveWorkbook.SendMail" but not a selected range. Can anyone help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sending a selection by email
Hi Canlink
Try this example if you use Outlook http://www.rondebruin.nl/mail/folder3/mail4.htm Or http://support.microsoft.com/default...b;en-us;816644 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Canlink" wrote in message ... I cannot find any VBA code to allow me to send a Selected Range as part of the body of an email. I can do this easily by first selecting the range; and the use MSExcel menu "File-Sent To-Mail Recipient" add email address and subject and then press "Send-Selection". I can send a whole workbook using VBA Code:- "ActiveWorkbook.SendMail" but not a selected range. Can anyone help? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sending a selection by email
Your code rocks!
Thanks, -- EddieV "Ron de Bruin" wrote: Hi Canlink Try this example if you use Outlook http://www.rondebruin.nl/mail/folder3/mail4.htm Or http://support.microsoft.com/default...b;en-us;816644 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Canlink" wrote in message ... I cannot find any VBA code to allow me to send a Selected Range as part of the body of an email. I can do this easily by first selecting the range; and the use MSExcel menu "File-Sent To-Mail Recipient" add email address and subject and then press "Send-Selection". I can send a whole workbook using VBA Code:- "ActiveWorkbook.SendMail" but not a selected range. Can anyone help? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sending a selection by email
Hi EddieV
I add a new page http://www.rondebruin.nl/mail/folder3/mailenvelope.htm This will also send a image in the body of the mail -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "LaRana!" wrote in message ... Your code rocks! Thanks, -- EddieV "Ron de Bruin" wrote: Hi Canlink Try this example if you use Outlook http://www.rondebruin.nl/mail/folder3/mail4.htm Or http://support.microsoft.com/default...b;en-us;816644 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Canlink" wrote in message ... I cannot find any VBA code to allow me to send a Selected Range as part of the body of an email. I can do this easily by first selecting the range; and the use MSExcel menu "File-Sent To-Mail Recipient" add email address and subject and then press "Send-Selection". I can send a whole workbook using VBA Code:- "ActiveWorkbook.SendMail" but not a selected range. Can anyone help? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sending a selection by email
hi,
Have a look here http://www.rondebruin.nl/mail/folder2/mail4.htm Mike "Canlink" wrote: I cannot find any VBA code to allow me to send a Selected Range as part of the body of an email. I can do this easily by first selecting the range; and the use MSExcel menu "File-Sent To-Mail Recipient" add email address and subject and then press "Send-Selection". I can send a whole workbook using VBA Code:- "ActiveWorkbook.SendMail" but not a selected range. Can anyone help? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sending a selection by email
On May 26, 11:55 am, Canlink wrote:
I cannot find any VBA code to allow me to send a Selected Range as part of the body of an email. I can do this easily by first selecting the range; and the use MSExcel menu "File-Sent To-Mail Recipient" add email address and subject and then press "Send-Selection". I can send a whole workbook using VBA Code:- "ActiveWorkbook.SendMail" but not a selected range. Can anyone help? Thanks Ron and Mike for directing me to Ron's page - I have tried Ron's Suggestion and it works wonderfully. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
| Sending a Spreadsheet as an Email Attachment vs. Imbedded in Email | Excel Discussion (Misc queries) | |||
| Sending Email via VBA | Excel Programming | |||
| Sending email with selection of data from spreadsheet | Excel Programming | |||
| sending a singular email by selection | Excel Programming | |||
Hybrid Mode
