Hi all,
I need a macro that runs on Outlook 2010 and does the following:
1. Open the excel attachment (the email would only have one attachment).
2. In Excel, go to Data, then Filter the headers
3. check whether cell "J1" is equal to a particular string, if so, use filter for column "J" and select "none". If not, abort.
3. check whether cell "O1" is equal to a particular string, if so, use filter for column "O" and select today's date (this column is dates). If not. abort.
4. column "H" is currencies. column "I" is amounts, for each currency, sum the amount in column "I". Normally there are 3 to 4 currencies.
5. Then the macro should generate an email with such information in the subject: the currency and its sum for each currency from step 4.
The email's from, to fields are also specified (it's fixed and do not change). My signature should also be placed in the email.
Any questions please let me know.
Thanks very much.
Kind Regards,
Jason
Hello
Thank you for the invite
Question - should I only look for emails with certain subject.
Should I process the email as soon as it is received or you want to run the macro at your convenience
Other points are fine
Timeline - 1 day to deliver you a draft for your test
Regards
Prem
Update:
Should the currency and sub total now in subject than the email body?
Also with your macro I simplifies and reduce the bid amount
$77 AUD in 3 days
4.7 (263 reviews)
6.3
6.3
20 freelancers are bidding on average $129 AUD for this job
Hi Jason. Instead of VB script, I can design a professional .Net Outlook Add in that shall be installable and accessible from top GUI ribbon. It shall read the attached Excel file and perform filtration as you require. You may also have the option to change email address to which email is sent. Please discuss. Regards.
Hi there - My name is Paris.
I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
Hi, my name is Sevinc. I am a 5-star excel and vba coding expert here. pls check my profile and feedbacks first to have some idea bout the quality of my previous works. I had many similar excel/office macro tasks, all achieved with 5/5 rating.. I read your excel/outlook macro project descriptions; I exactly got what you need and ready to go ahead as soon as we can discuss further project details...kindly get back to me if you wish to proceed with a top-rated and reliable partner here. pls note that I only deliver best quality at a reasonable price, and Im open for longterm partnerships...I bid my best for you to start...regards,
hey Jason, thanks for the detailed description...we can write this excel/outlook macro... (we have done such stuff earlier as well)...please reply...we can discuss further...thank you...
Greetings for the Day!!!
I have 6 years of experience in VBA Macros, VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases.
hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction.
please award me this project and contact me for further details
Thanks
Prabakar M
Hello,
I can start working now and finish this project on time with the least cost. I have done similar kind of work earlier. I can provide you the output in just 6 hours.
Please consider myself for this project.
Thank you very much.
Hey Jason! My name is Peter, I very recently moved to the silicon valley area and am trying to make my dream work.
As for the project at hand, I have spent the last several months writing very similar macros for a major healthcare company. They were extremely pleased with my work and my efforts led to a 30% increase in production for one of their departments. The macros themselves were based in excel but accessed outlook functions, but the reverse will be no problem. I would deliver top-notch work for a reasonable price that still guarantees good results.
I have worked on a similar projects in Bank of America. I would process Sales' call reports and generate emails with data extracted from the attachments. I am an expert in VBA behind the whole MS Office suite (Word, Excel, Access, Outlook and Powerpoint). I work accurately and I take pride in my intelligence. Please drop me a line if you would like to award a project to me
Best regards,
Morris
Hello sir,
I ready to start now. I know critical Excel formula so don't worry I could be done everything accurately. please tell me How many data you have.
I hope your soon reply.
Regards,
ANANDA
I am Dayanand Patil having 6+ years of development experience for Microsoft technology based applications (Windows and Web based). In-depth knowledge and experience in systems architecture, software design methodologies, design patterns and object oriented design.
I have also developement experienced in VBA(macro) in more than 3 projects which include MS excel & MS outlook interaction .
I have done more than 100 excel dashboards / reports are automated through macro. I have used db2 database and MS Access database also. I have developed a excel macro tool for multi-user .