Đang Thực Hiện

Microsoft Outlook rules 2

My website has two separate submission forms.(WF1 and WF2) When someone submits either WF1 or WF2 all of the information that person inputted into the form is transcribed into the body of an email and then sent to my email. Each input field of either WF1 or WF2 will be on a separate line of the email. The emails will enter into my Inbox. WF1 comes from one email address and WF2 comes from a different email address. WF1 and WF2 are similar to each other the only difference between WF1 and WF2 is WF1 has a manager name and email plus 1 additional name and email plus 1 additional schedule plus 1 additional Zip Code list. WF2 has a manager name and email plus 8 additional names and emails plus 10 additional schedules plus 10 Zip Code lists.

ACTION 1

The inbox has 3 subfolders (SF1, SF2 and SF3). SF1 and SF2 should have identical properties and the same actions should happen whether I use subfolder SF1 or SF2.

If I drag and drop an email from the inbox to either SF1 or SF2 the following actions should happen:

1. All of the information in the email should be re-formatted into a excel spreadsheet (ES) so it's easier to read.

2. The new ES needs to be printed.

3. A new email needs to be opened.

4. The new ES needs to be attached to the new email.

5. The new email should be sent to all of the email addresses that were entered into WF1 or WF2.

6. Both WF1 and WF2 has a required field named "organization" (RFO). The name entered into RFO should be cross referenced with a excel spreadsheet that I have on my computer. (MES). MES will list all possible RFO entries with corresponding email addresses. The matching email addresses on the MES should be added to new email created in step 3 and sent with the other emails in step 5.

[url removed, login to view] MES will also have a corresponding list of files per RFO that should be attached to the new email created in step 3 before it is sent in step 5.

8. WF1 and WF2 has the same section "Would you like instructional material emailed?" if this is checked yes they can check up to 5 things they want emailed to them. Each of the items they are requesting should be attached to the new email created in step 3 before it is sent in step 5.

[url removed, login to view] body of the email created in step 3 should have generic text as a default. I should be able the change the default text at any time.

10. I will need to manually send the email myself.

ACTION 2

The same actions should happen when I drag and drop an email from either SF1 or SF2 to SF3:

1. A new email needs to be opened.

2. The ES that was created in Action 1 should be created again and attached to the new email created in step 1.

[url removed, login to view] new email should be sent to all of the email addresses that were entered into WF1 or WF2.

4. Both WF1 and WF2 has a required field named "organization" (RFO). The name entered into RFO should be cross referenced with a excel spreadsheet that I have on my computer. (MES). MES will list all possible RFO entries with corresponding email addresses. The matching email addresses on the MES should be added to new email created in step 1 and sent with the other emails in step 3.

5. A special list of email addresses should be added to the new email created in step 1 before it is sent in step 3. I should be able to edit the list of special email addresses at any time.

[url removed, login to view] body of the email created in step 1 should have generic text as a default. I should be able the change the default text at any time.

7. I will need to manually send the email myself.

Kỹ năng: Microsoft Exchange

Xem thêm: printed names, my schedule plus, microsoft excel spreadsheet, rules, outlook 2013, drag drop excel, enter email addresses excel spreadsheet, form drop outlook, outlook properties, matching files excel, excel matching files, outlook 2013 exchange, microsoft excel 2013, exchange emails, matching excel files, properties drag, manually send emails, material emails, outlook body excel, exchange microsoft, separate address lists exchange 2013, use outlook, drag drop matching, drag email form, vba script add rules outlook

Về Bên Thuê:
( 2 nhận xét ) Columbus, United States

Mã Dự Án: #4553422

Đã trao cho:

oFAZo

I am a VBA expert by profession and specialize in automating MS Office 2003-2010. As a matter of fact this is my core job at my workplace. I would be glad to have the opportunity to provide a solution for you. Please c Thêm

$225 USD trong 4 ngày
(0 Đánh Giá)
0.0

2 freelancer đang chào giá trung bình $390 cho công việc này

LinuxScript

Hello I am interested in your project.

$555 USD trong 7 ngày
(0 Đánh Giá)
0.0