Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-17 Thread shraddha malvankar
>>>> .Range("g6").Value = Sheets("data").Range("d" & i).Value >>>>>> .Range("a8").Value = Sheets("data").Range("e" & i).Value >>>>>> .Range("g8").Value

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-17 Thread ashish koul
Sheets("data").Range("f" & i).Value >>>>> .Range("a10").Value = Sheets("data").Range("g" & i).Value >>>>> .Range("g10").Value = Sheets("data").Range("h" & i).Value >>>

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-16 Thread shraddha malvankar
h" & i).Value >>>> .Range("a12").Value = Sheets("data").Range("i" & i).Value >>>> End With >>>> >>>> 'send email now >>>> Sheets("Verification").Copy >>>>

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-16 Thread ashish koul
y_hh_mm_ss") & ".xlsx" >>> Set wkb = ActiveWorkbook >>> wkb.SaveAs flname >>> >>> Set olMail = objOL.CreateItem(olMailItem) >>> With olMail >>> .To = Sheets("Verification").Range("a12") >

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-16 Thread shraddha malvankar
With olMail >> .To = Sheets("Verification").Range("a12") >> .Subject = "Verification" >> .Attachments.Add flname >> .Body = "Please verfiyy--" >> .display >> End With

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-14 Thread shraddha malvankar
e > > Set olMail = objOL.CreateItem(olMailItem) > With olMail > .To = Sheets("Verification").Range("a12") > .Subject = "Verification" > .Attachments.Add flname > .Body = "Please verfiyy--

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-13 Thread ashish koul
heets("Verification").Range("a12") .Subject = "Verification" .Attachments.Add flname .Body = "Please verfiyy--" .display End With wkb.Close Kill flname Set olMail = Nothing Next Set olApp = Noth

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-13 Thread koul . ashish
-Macros$$ Copy Past Macro help Hi, Need help in macro for attached file. I have one excel sheet where as I have around 500 vendors and I need to send mail to each vendor as per their email id but after filling up their respective data in verification sheet. I would like to auto populate

$$Excel-Macros$$ Copy Past Macro help

2013-09-13 Thread shraddha malvankar
Hi, Need help in macro for attached file. I have one excel sheet where as I have around 500 vendors and I need to send mail to each vendor as per their email id but after filling up their respective data in verification sheet. I would like to auto populate the filed from data sheet to Ve

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-13 Thread shraddha malvankar
alvankar > > *Sender: * excel-...@googlegroups.com > *Date: *Fri, 13 Sep 2013 10:57:37 -0700 (PDT) > *To: *> > *ReplyTo: * excel-...@googlegroups.com > *Subject: *$$Excel-Macros$$ Copy Past Macro help > > Hi, > > > > Need help in macro for attached file.