Закрито

An Excel/Outlook Macro

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

Навички: Microsoft Office, Microsoft Outlook, Архітектура ПЗ, Visual Basic

Показати більше: string j, outlook visual basic, j1, visual basic currency, outlook 2010 date, visual currency, outlook signature visual basic, excel macro outlook calendar, macro outlook 2010 export emails excel, use outlook, please check excel attachment, visual basic 2010 macro, macro fields excel, filter subject macro outlook, macro outlook 2010, kind excel, excel filter, macro email data excel, excel macro outlook, macro software, outlook 2010 email, macro outlook excel, excel 2010 macro, change macro, generate data excel macro

Про роботодавця:
( 0 відгуки(-ів) ) Pondicherry, India

ID проекту: #6953947

16 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $112

Humpt

Hello. I can complete your task. I have VBA knowledge and one of my last job was a communication with excel files. I can start today and in one / three days I will deliver you the results. At first I would like to see Більше

$144 AUD за 3 дні(-в)
(3 відгуків(-и))
4.3
gperete

Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office.

$50 AUD за 1 день
(9 відгуків(-и))
3.7
mkhrsunil

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 con Більше

$225 AUD за 3 дні(-в)
(3 відгуків(-и))
3.1
Lane2

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 Більше

$88 AUD за 5 дні(-в)
(4 відгуків(-и))
3.1
prabakarm23

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 Serv Більше

$83 AUD за 1 день
(5 відгуків(-и))
2.4
nellaistores

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 дні(-в)
(1 відгук)
2.0
rodweb

Aucune proposition n'a encore été fournie.

$111 AUD за 2 дні(-в)
(1 відгук)
1.0
Ananth9

Dear Sir/Madam I read your project description. I am interested to do this work. I have good knowledge in visual basic, Excel macro. I will complete the work on time as per your budget amount. Please give me a oppor Більше

$111 AUD за 3 дні(-в)
(0 відгуків(-и))
0.0
morrisstarling

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 L Більше

$70 AUD за 2 дні(-в)
(0 відгуків(-и))
0.0
TebrexBusiness

I am an Excel developer, I developed over 100 Excel programs, so this is an easy job for me. I will do everything that you are asking for, for reasonable price. I went on University of Economics, department for Busin Більше

$111 AUD за 3 дні(-в)
(0 відгуків(-и))
0.0
divyashanbhag16

A proposal has not yet been provided

$111 AUD за 3 дні(-в)
(0 відгуків(-и))
0.0
hash868

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
sahilsinghal0410

A proposal has not yet been provided

$55 AUD за 2 дні(-в)
(0 відгуків(-и))
0.0
Alex2703

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 Більше

$66 AUD за 3 дні(-в)
(0 відгуків(-и))
0.0
prakmvm

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
ledeakin

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