| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mail worksheet in Body AND Attach File
Hi,
I'm successfully using Ron DeBruin's great code found here (http://www.rondebruin.nl/mail/folder3/mail2.htm) to send emails with an Excel worksheet in the body of the mail. What I'd like to do, but have not been successful, is also attaching the Excel file to the email. I thought this might be straightforward, by taking code from Ron's other examples, but it hasn't worked. I've tried adding the line: Attachments.Add <PATH I don't get an error, but I also don't get the attachment. Can anyone offer any suggestions here as to how I might get this to work? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Mail worksheet in Body AND Attach File
Hi Ben
Try this ..Attachments.Add ("C:\test.txt") -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "BenS" wrote in message ... Hi, I'm successfully using Ron DeBruin's great code found here (http://www.rondebruin.nl/mail/folder3/mail2.htm) to send emails with an Excel worksheet in the body of the mail. What I'd like to do, but have not been successful, is also attaching the Excel file to the email. I thought this might be straightforward, by taking code from Ron's other examples, but it hasn't worked. I've tried adding the line: Attachments.Add <PATH I don't get an error, but I also don't get the attachment. Can anyone offer any suggestions here as to how I might get this to work? Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Mail worksheet in Body AND Attach File
Hi Ron,
That did it! Thank you so much, not only for the lightning fast reply, but for all of the information on your web page. I can't tell you how many times I've been able to solve a problem at work thanks to your site. Kind regards, Ben "Ron de Bruin" wrote: Hi Ben Try this ..Attachments.Add ("C:\test.txt") -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "BenS" wrote in message ... Hi, I'm successfully using Ron DeBruin's great code found here (http://www.rondebruin.nl/mail/folder3/mail2.htm) to send emails with an Excel worksheet in the body of the mail. What I'd like to do, but have not been successful, is also attaching the Excel file to the email. I thought this might be straightforward, by taking code from Ron's other examples, but it hasn't worked. I've tried adding the line: Attachments.Add <PATH I don't get an error, but I also don't get the attachment. Can anyone offer any suggestions here as to how I might get this to work? Thanks! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Mail worksheet in Body AND Attach File
You are welcome
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "BenS" wrote in message ... Hi Ron, That did it! Thank you so much, not only for the lightning fast reply, but for all of the information on your web page. I can't tell you how many times I've been able to solve a problem at work thanks to your site. Kind regards, Ben "Ron de Bruin" wrote: Hi Ben Try this ..Attachments.Add ("C:\test.txt") -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "BenS" wrote in message ... Hi, I'm successfully using Ron DeBruin's great code found here (http://www.rondebruin.nl/mail/folder3/mail2.htm) to send emails with an Excel worksheet in the body of the mail. What I'd like to do, but have not been successful, is also attaching the Excel file to the email. I thought this might be straightforward, by taking code from Ron's other examples, but it hasn't worked. I've tried adding the line: Attachments.Add <PATH I don't get an error, but I also don't get the attachment. Can anyone offer any suggestions here as to how I might get this to work? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sending a Mail from outlook with body coming from excel file | Excel Discussion (Misc queries) | |||
| How can you attach an e-mail into an excel worksheet? | Excel Worksheet Functions | |||
| Convert to HTML and e-mail selection as the body of the e-mail. | Excel Programming | |||
| Copy a sheet to the body of an email or attach part of a spreadsheet | Excel Programming | |||
| Mail Worksheet as (html) message body | Excel Programming | |||
Linear Mode
