Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail

hi Noorain thanks a lot. i am expecting Ans like this only On Feb 21, 3:58 pm, NOORAIN ANSARI wrote: > For advance Hyperlink, You can visit > on..http://datapigtechnologies.com/blog/index.php/emailing-from-excel-usi... > -- > Thanks & regards, > Noorain Ansari >  *http://noorainansa

Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail

For advance Hyperlink, You can visit on.. http://datapigtechnologies.com/blog/index.php/emailing-from-excel-using-the-hyperlink-function/ -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Tue, Feb 21,

Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail

Hi Renuka, Try it.. =HYPERLINK("mailto:"&G2&"?bcc=noorain.ans...@gmail.com&Subject=Ladger statement",G2) -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Tue, Feb 21, 2012 at 11:33 AM, renuka chari

Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail

hi Noorain i know that formula, but i neet To Address,bcc Address & Subject. At a Single glance thanks On Feb 19, 11:34 am, NOORAIN ANSARI wrote: > Dear Vijay/Renuka, > > Please use it to keep subject line while opening new outlook window.. > > *=HYPERLINK("**mailto:"&G2&"?Subject="&"

Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail

Hi Noorain, It will work only one cell at a time, is it possible to put subject to multiple cellls at a time. Regards, Vijayendra 2012/2/17 NOORAIN ANSARI > Hi Renu, > > Please see attached Screen shot, it might be helpful > > > On Fri, Feb 17, 2012 at 1:17 PM, Renukachari Kasee wrote: > >>

Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail

hi it was not work actually in my excel backend some code is there once can you check tahat and give me solution for that thanks for ur valueble replay On Feb 17, 4:48 am, NOORAIN ANSARI wrote: > Hi Renu, > > Please see attached Screen shot, it might be helpful > > On Fri, Feb 17, 2012 at 1:1