Re: $$Excel-Macros$$ Macro to send emails using excel list

2010-05-18 Thread WizExcel
This is Superb Mahesh. really helpful for anyone who wants to send repetitive emails to a list of persons. Can anyone please also tell me its utility from Finance Dept. point of view, what functions have you used this Macro for. thanks Sameer On May 15, 10:49 am, Mahesh parab wrote: > Hi > In

Re: $$Excel-Macros$$ Macro to send emails using excel list *

2010-05-17 Thread Intelligent But Crazy
Hi Mahesh, Thanks a lot, this is working fine now. i m great full to you. could you pls give me one more help. i want to use check names option in outlook. so what code should i use in this macro. Thanks Pankaj k Pandey On 5/18/10, Mahesh parab wrote: > Hi > > You can do below menti

Fwd: $$Excel-Macros$$ Macro to send emails using excel list *

2010-05-17 Thread Mahesh parab
Hi You can do below mention changes to add CC,BCC in mail .To = Cells(cell.Row, "D").Value .CC = Cells(cell.Row, "E").Value .BCC = Cells(cell.Row, "F").Value change the column name as per your requirement. if you want to add yesterday's date in boday of mail then you can use below mention code .B

Re: $$Excel-Macros$$ Macro to send emails using excel list

2010-05-16 Thread Intelligent But Crazy
Hi Mahesh, Thanks a lot for this help, this is really too helpfull for all outlook users. I also want to know that if i have to add CC or BCC in mail so what the changes i have to do in macro. & n pls also tell me if i have to add yesterday date in body of the mail every da

$$Excel-Macros$$ Macro to send emails using excel list

2010-05-14 Thread Fabio Sascho
Dear friends Below you can find the code I wrote to make Excel send emails thought a list of names My problem is the attachment talk. I need a code that gets all files from a certain directory and attach into the email using the " .attachment.Add" Does anyone know how to do that ?