Concluído

Excel VBA to filter and send email

I have an excel spreadsheet of raw data in Sheet1. The raw data should remain intact.

There are a variable number of keywords, E.g. meeting, conference, briefing, etc.

Based on the data in "Trip Description" (Column M), remove records if they contain these keywords.

Make it so that this is a loop based on number of keywords.

Based on the "Pick Up Time Local" in Column G, remove records if it is on Saturday or Sunday.

Based on the "Pick Up Time Local" in Column G, remove records if they are before 7am or after 9pm.

There is a variable number of Known_Addresses.

If Pick Up Address (Column I) and Drop Off Address (Column J) both matches the set of Known_Addresses, remove the records.

For the remaining records, display them in another worksheet. The user can delete some of these records, and may leave black rows.

Create a button on the sheet for the user to send a email to all the people in the records.

The email shall be sent to "Employee Email Address" (Column F), with subject "test", and the body that includes Dear <Employee Name (Column B)>,

Please provide readable codes as I will be making changes to them

Habilidades: Excel, Visual Basic, Visual Basic para Apps

Veja mais: excel vba com send parameter word macro, send email excel automatically outlook, send email excel automatically, excel vba filter sheets, send email excel outlook, excel vba filter, ruby rails send email excel, excel vba filter different line, macro send email excel data, macro send email excel, excel vba filter table, send email excel, excel vba filter drop down list, excel vba link in email, excel vba filter based on cell value on another sheet, excel vba filter pivot table based on multiple cell values, excel macro to send email automatically, excel vba filter column based on cell value

Acerca do Empregador:
( 0 comentários ) Singapore, Singapore

ID do Projeto: #29969835

Concedido a:

Wanngming

Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with email handling using Excel VBA. Everyone call me a "Prince of Excel". I promise I will finish this Mais

$30 SGD em 1 dia
(3 Comentários)
2.3

4 freelancers estão ofertando em média $61 nesse trabalho

(199 Comentários)
6.9
(32 Comentários)
5.0
sergidest

Hi, there. I have read your project description very carefully so I had confidence that I can do it. But some problem you need for the project will discuss with me before starting work, I think. I have experience over Mais

$12 SGD em 1 dia
(1 Comentário)
0.4