Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-15 Thread dguillett1
Glad to hep Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: renuka chari Sent: Wednesday, February 15, 2012 12:27 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA Hi dguillett1 Its

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-15 Thread renuka chari
Hi Don Guillett is there any way to keep subject line also while opening that link thanks for every one On Feb 14, 8:44 pm, "dguillett1" wrote: > Don Guillett > SalesAid Software > dguille...@gmail.com > > From: Renukachari Kasee > Sent: Tuesday, February 14, 2012 6:21 AM > To: excel-macros@g

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread PrIyAnKa
Dear Renuka kindly check the below link , it might be helpful to u http://www.rondebruin.nl/mail/folder2/mail5.htm On Wed, Feb 15, 2012 at 11:55 AM, renuka chari wrote: > ya, sending on daily basis > > On Feb 14, 12:25 pm, Mahesh parab wrote: > > Hi > > > > Do you want to send bulk emails t

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread renuka chari
thanks maries And All On Feb 14, 2:02 pm, Maries wrote: > Hi, > > Find the attached file. > > Regards, > > MARIES. > > > > > > > > On Tue, Feb 14, 2012 at 9:25 PM, Mahesh parab wrote: > > Hi > > > Do you want to send bulk emails to respective person from that worksheet ? > > > HTH > > Mahesh > >

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread renuka chari
Hi dguillett1 Its working Good Thank you so much On Feb 14, 10:44 am, "dguillett1" wrote: > Right click sheet tab>view code insert this. Now when you select col G (no > need for col H) > > Private Sub Worksheet_SelectionChange(ByVal Target As Range) > On Error GoTo nomo > If Target.Colu

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread renuka chari
ya, sending on daily basis On Feb 14, 12:25 pm, Mahesh parab wrote: > Hi > > Do you want to send bulk emails to respective person from that worksheet ? > > HTH > Mahesh > > > > > > > > On Tue, Feb 14, 2012 at 9:14 PM, dguillett1 wrote: > > > Don Guillett > > SalesAid Software > > dguille...@gmai

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread Maries
Hi, Find the attached file. Regards, MARIES. On Tue, Feb 14, 2012 at 9:25 PM, Mahesh parab wrote: > Hi > > Do you want to send bulk emails to respective person from that worksheet ? > > > HTH > Mahesh > > > On Tue, Feb 14, 2012 at 9:14 PM, dguillett1 wrote: > >> >> >> Don Guillett >> SalesAid

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread Mahesh parab
Hi Do you want to send bulk emails to respective person from that worksheet ? HTH Mahesh On Tue, Feb 14, 2012 at 9:14 PM, dguillett1 wrote: > > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Renukachari Kasee > *Sent:* Tuesday, February 14, 2012 6:21 AM > *To:* excel-

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread dguillett1
Don Guillett SalesAid Software dguille...@gmail.com From: Renukachari Kasee Sent: Tuesday, February 14, 2012 6:21 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA Hi All experts good evening here one sheet is having h

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread dguillett1
Right click sheet tab>view code insert this. Now when you select col G (no need for col H) Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error GoTo nomo If Target.Column = 7 And Target <> "" Then ActiveWorkbook.FollowHyperlink Address:= _ "mailto:"; & Target & "?bcc=$J$1," & Tar