Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emailing an Excel File with a Macro through Outlook
Tyson,
Try Ron de Bruin's site for code examples (and an Add-In that might automate the process for you) http://www.rondebruin.nl/sendmail.htm John Tysone wrote: What I'm trying to do is write something in VB that will allow me to send an excel file as an attachment through Outlook. My Email Address will always be in D5 and my Subject will always be in C3. I have searched a bunch of news groups, but I can't find something that I can adapt to my needs. I'm not much of a programmer, but I can cut and paste with the best of them. Any help would be awesome. Thanks for your time, Tyson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emailing an Excel File with a Macro through Outlook
Is there a toggle switch out there for the outlook warning? The one
where it prompts you to say yes or no to the fact you computer is going to auto send an email... Normally this is a great function, but once a month I would like to turn it off and run it warning free. Thanks John Wilson wrote in message ... Tyson, Try Ron de Bruin's site for code examples (and an Add-In that might automate the process for you) http://www.rondebruin.nl/sendmail.htm John Tysone wrote: What I'm trying to do is write something in VB that will allow me to send an excel file as an attachment through Outlook. My Email Address will always be in D5 and my Subject will always be in C3. I have searched a bunch of news groups, but I can't find something that I can adapt to my needs. I'm not much of a programmer, but I can cut and paste with the best of them. Any help would be awesome. Thanks for your time, Tyson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emailing an Excel File with a Macro through Outlook
Hi Tysone
In OE you can swith it on and of in ToolsOptions But not in Outlook -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Tysone" wrote in message om... Is there a toggle switch out there for the outlook warning? The one where it prompts you to say yes or no to the fact you computer is going to auto send an email... Normally this is a great function, but once a month I would like to turn it off and run it warning free. Thanks John Wilson wrote in message ... Tyson, Try Ron de Bruin's site for code examples (and an Add-In that might automate the process for you) http://www.rondebruin.nl/sendmail.htm John Tysone wrote: What I'm trying to do is write something in VB that will allow me to send an excel file as an attachment through Outlook. My Email Address will always be in D5 and my Subject will always be in C3. I have searched a bunch of news groups, but I can't find something that I can adapt to my needs. I'm not much of a programmer, but I can cut and paste with the best of them. Any help would be awesome. Thanks for your time, Tyson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emailing an Excel File with a Macro through Outlook
I take the no responce as a no to this question?
(Tysone) wrote in message . com... Is there a toggle switch out there for the outlook warning? The one where it prompts you to say yes or no to the fact you computer is going to auto send an email... Normally this is a great function, but once a month I would like to turn it off and run it warning free. Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emailing an Excel File with a Macro through Outlook
You need Outlook code to do this.
Try this http://www.rondebruin.nl/sendmail.htm#other -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Tysone" wrote in message om... in this macro ActiveWorkbook.SendMail Sheets("mysheet").Range("D5").Value, _ Sheets("mysheet").Range("C3").Value Is there a way I can have it also have a standard Body of the email? I.E. how you can have: .Body & "blablabla" Or does anyone know a better macro? Thanks! (Tysone) wrote in message . com... I take the no responce as a no to this question? (Tysone) wrote in message . com... Is there a toggle switch out there for the outlook warning? The one where it prompts you to say yes or no to the fact you computer is going to auto send an email... Normally this is a great function, but once a month I would like to turn it off and run it warning free. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
emailing from excel 2003 thru outlook 2007 is not being recieved | Excel Worksheet Functions | |||
Automatic emailing Excel content via Outlook (for Student grading) | New Users to Excel | |||
How do I get Excel to use my normal Outlook profile when emailing | Excel Discussion (Misc queries) | |||
Macro Emailing an XLS via Outlook | Excel Discussion (Misc queries) | |||
macro for e-mailing excel file using outlook | Excel Programming |