$$Excel-Macros$$ - Download attachments and merge spreadsheets

2014-02-01 Thread BUNTY
Dear Gurus, I need serious help from you all I receive almost 400 mails every day with specific subject, attachment name and fixed sender. Is there a way to download attachments automatically from outlook and place it in to the respective folders. Also these attachments data structure i

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

2014-02-01 Thread Atul Kesaria
Hi PFA fileplease note that the attachment which need to go with each mail would be a PDF file. On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria wrote: > PFA > > > On Sat, Feb 1, 2014 at 7:45 PM, ashish koul wrote: > >> please share a sample file >> >> >> On Sat, Feb 1, 2014 at 5:19 PM, Atul K

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

2014-02-01 Thread Atul Kesaria
PFA On Sat, Feb 1, 2014 at 7:45 PM, ashish koul wrote: > please share a sample file > > > On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria wrote: > >> Hi Team, >> >> I need a help in getting a macro which will help sending email with >> attachment to list of person in the excel sheet which will hav

Re: $$Excel-Macros$$ sent automatically in email

2014-02-01 Thread ashish koul
can u share a sample file On Sat, Feb 1, 2014 at 11:14 AM, Lakshman P <305laksh...@gmail.com> wrote: > Dear expart, > > I am trying to have reports in Excel (that are udpated daily) sent > automatically in email. I want them to just be sent "behind the scenes" > without me having to create a new

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

2014-02-01 Thread ashish koul
please share a sample file On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria wrote: > Hi Team, > > I need a help in getting a macro which will help sending email with > attachment to list of person in the excel sheet which will have there Name, > email ID,Unique number. Please note that every person

$$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

2014-02-01 Thread Atul Kesaria
Hi Team, I need a help in getting a macro which will help sending email with attachment to list of person in the excel sheet which will have there Name, email ID,Unique number. Please note that every person should receive a particular file based on their unique number. File are prestored in a part

$$Excel-Macros$$ Re: [XL-VBA Clinic] Offset Query

2014-02-01 Thread Rakesh Kumar Sharma
correct bhai Thank you So much Saurabh Ji. On Sat, Feb 1, 2014 at 12:54 PM, saurabh kumar wrote: > Hi Rakesh, > > Please use below with CSE. > > =OFFSET(INDEX($A$4:$A$27,MATCH($M$1,A4:A27,0)),0,3,6,COUNTA(N4:U4)) > > Changes is highlighted. > > Regards > Saurabh > > > On Sat, Feb 1, 2014 at 12: