Find Jobs
Hire Freelancers

An Excel/Outlook Macro

$30-250 AUD

Закрито
Опублікований about 9 years ago

$30-250 AUD

Оплачується при отриманні
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
ID проекту: 6953947

Про проект

13 пропозицій(-ї)
Дистанційний проект
Активність 9 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
13 фрілансерів(-и) готові виконати цю роботу у середньому за $114 AUD
Аватарка користувача
Aucune proposition n'a encore été fournie.
$111 AUD за 2 дні(-в)
4,9 (28 відгуки(-ів))
5,0
5,0
Аватарка користувача
Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., 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
$83 AUD за 1 день
5,0 (40 відгуки(-ів))
4,8
4,8
Аватарка користувача
Hi, I'm VBA developer and I already worked on half of this project Please share some sample mails with attachments and mail format to send mails with subject line how you want to run it? 1) as per date condition - by default, tool will run as per today's date and download each attachment and process your 4 conditions and will save attachment. 2) Automatically mail will generate with To, Subject & your signature but you didn't mentioned mail body format? Please PM me means i can start working on same and share demo with you before award this project Thanks
$225 AUD за 3 дні(-в)
5,0 (3 відгуки(-ів))
3,5
3,5
Аватарка користувача
Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office.
$50 AUD за 1 день
4,9 (10 відгуки(-ів))
3,6
3,6
Аватарка користувача
I'm a expert of Outlook Plugin development, I developed many Outlook plugin/macros during my work. All my bidding projects here are related to Office plugin, I finished them on time and got very good feedback, and you can refer to my finished projects for this. It's easy to use VBA macro to manipulate excel file, read the content, filter and calculate data, and finally send mail according to your requirement. It would be great if you can give me the sample excel file.
$88 AUD за 5 дні(-в)
4,9 (5 відгуки(-ів))
3,7
3,7
Аватарка користувача
I'm an MS Office expert and I am proficient with working with VBA in Excel, Outlook as well as Word and Access. The specification seems to be straightforward and I could start working on your project straight away Let me know if you would like to accept my bid Regards Morris
$70 AUD за 2 дні(-в)
4,8 (5 відгуки(-ів))
3,3
3,3
Аватарка користувача
Hi you can look at my porfolio and projects. I am quite knowledgable in Macros and get this job completed for you in 2 days.
$100 AUD за 3 дні(-в)
5,0 (3 відгуки(-ів))
2,6
2,6
Аватарка користувача
A proposal has not yet been provided
$111 AUD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
i have design similar macro Excel files ! Excel as you desire can be completed in day and also it can be modified in future by means of variable programmable fields.
$100 AUD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I can make this with a macro without problem. The only thing that we should review is the Outlook permisions to send files authomatically, for security (if enabled) your account will ask for confirmation (an accept button ) prior sending any email. I can deliver and make about two corrections after delivery if i am selected. Regards
$66 AUD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Since i have used excel through out my 14 years of my career ,where my day to day reports which required lot of automation which where automated by me with the help of macro
$250 AUD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hello there, I frequently write macros that extract data from excel. This will be easy for me to complete in a timely manner.
$111 AUD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор INDIA
Pondicherry, India
0,0
0
На сайті з січ. 5, 2015

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.