Re: $$Excel-Macros$$ Emailing from Spreadsheet

2011-08-02 Thread Vincent Torralbes
Forgot to attach email On Tue, Aug 2, 2011 at 8:55 AM, Vincent Torralbes wrote: > Thank you Rajan, this certainly helps, but it doesn't maintain the > formatting. Attached is the format I'm trying to maintain on the email > body. Also, when I click on the button (execute macro), it gives me

Re: $$Excel-Macros$$ Emailing from Spreadsheet

2011-08-02 Thread Vincent Torralbes
Thank you Rajan, this certainly helps, but it doesn't maintain the formatting. Attached is the format I'm trying to maintain on the email body. Also, when I click on the button (execute macro), it gives me a message that an external program is trying to email where I have to click on "Allow" afte

Re: $$Excel-Macros$$ Emailing from Spreadsheet

2011-08-02 Thread Venkat CV
Hi Vinne, x...@1223.com,a...@bcz.com,y...@ind.com Just use like Email id's above in single cell and click in Excel Cell the above all these id's in To address of New Mail in your Outlook. *Best Regards,* *Venkat* *Chennai* On Tue, Aug 2, 2011 at 5:56 PM, Vincent Torralbes wrote: > I hav

RE: $$Excel-Macros$$ Emailing from Spreadsheet

2011-08-02 Thread Rajan_Verma
See the attached Sheet You can Change the Subject according to You by in VBE: Sub SenDmail() Dim outLookApp As Outlook.Application Set outLookApp = New Outlook.Application Dim Msg As String Dim mitem As Object Dim cell As Range For Each cell In Range("Range") Msg = Msg & cell.Val