Macro To Create Rule To Export From Certain Folder Email Information in one workbook multiple sheets

Status
Not open for further replies.

Brad Bell

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server 2013
I am trying to create a script rule that automatically exports email body information when received into a predesigned spreadsheet that is done throughout the week but daily it is updated with the info. At the end of the week a new sheet is created for the following week. The email body looks like this. I will attach the spreadsheet layout also in about 10 mins.

Data Below is calculated Midnight-to-Midnight (Eastern Time) **=--- ** Wireless DTC shipped 38718 order-lines, 8593 handsets and 30170 accessories. Total of 8061 orders or 8077 cartons shipped and cancelled/zero-shipped 121 orders on 06/27/2016 with avg order-entry to ship of 37.49 hrs verses an internal WMS cycle time of 4.51 hrs. Order SLA (7PM CDT) fill-rate: 99.9211% with 14 orders/180 lines missed SLA. Order shipped fill-rate: 99.8%. 7247 cartons w/one or more phones and 830 accy-only cartons shipped. 8734 orders, 38367 order-lines downloaded yesterday while available for planning is 87 orders and 808 lines. ** DSL DTC shipped 9133 order-lines, 705 modems/routers and 8319 components. Total of 1058 orders or 1092 cartons shipped and cancelled/zero-shipped 0 orders on 06/27/2016 with avg order-entry to ship of 35.42 hrs verses an internal WMS cycle time of 8.02 hrs. Order SLA (3PM CDT) fill-rate: 100% with 2 orders/20 lines missed SLA. Order shipped fill-rate: 100%. 705 cartons w/one or more modems/routers and 387 accy-only cartons shipped. 740 orders, 12912 order-lines downloaded yesterday while available for planning is 154 orders and 1649 lines. ** UVERSE DTC shipped 33757 order-lines, 3728 STBs/RGs and 27562 components. Total of 5961 orders or 5966 cartons shipped and cancelled/zero-shipped 0 orders on 06/27/2016 with avg order-entry to ship of 44.54 hrs verses an internal WMS cycle time of 5.6 hrs. Order SLA (9PM CDT) fill-rate: 93.5771% with 720 orders/5435 lines missed SLA. Order shipped fill-rate: 99.8%. 3642 cartons w/one or more STBs/RGs and 2324 accy-only cartons shipped. 6729 orders, 48088 order-lines downloaded yesterday while available for planning is 3081 orders and 22630 lines. ** Wireless BULK shipped 24421 order-lines, 22465 handsets and 67425 accessories. Total of 3138 orders or 6440 cartons shipped and cancelled/zero-shipped 6 orders on 06/27/2016 with avg order-entry to ship of 466.43 hrs verses an internal WMS cycle time of 9.79 hrs. Order SLA (5PM CDT) fill-rate: 86.3166% with 558 orders/6539 lines missed SLA. Order shipped fill-rate: 99.6%. 4937 cartons w/one or more phones and 1503 accy-only cartons shipped. 3728 orders, 34313 order-lines downloaded yesterday while available for planning is 58 orders and 105 lines. ** DSL LFO(BULK) shipped 35 order-lines, 1292 modem/routers and 30 components. Total of 33 orders or 222 cartons shipped and cancelled/zero-shipped 0 orders on 06/27/2016 with avg order-entry to ship of 181.61 hrs verses an internal WMS cycle time of 47.6 hrs. Order SLA (3PM CDT) fill-rate: 100% with 3 orders/5 lines missed SLA. Order shipped fill-rate: 99.9%. 3 cartons w/one or more modems/routers and 219 accy-only cartons shipped. 6 orders, 13 order-lines downloaded yesterday while available for planning is 0 orders and 0 lines. ---=** Data Above is calculated Midnight-to-Midnight (Eastern Time) **=--- ---=** Data Below is calculated based on Carryover Cutoff time (4am-4am) **=--- ---=** [Hours are displayed in Eastern Time] **=--- ** MDC WMS Orders shipped by hour - 06/27/2016 06/27 07:00 Wireless DTC: 25 orders 111 lines 111 units 06/27 08:00 Wireless DTC: 414 orders 2075 lines 2076 units 06/27 09:00 Wireless DTC: 566 orders 2134 lines 2141 units 06/27 10:00 Wireless DTC: 722 orders 3026 lines 3026 units 06/27 11:00 Wireless DTC: 514 orders 2295 lines 2295 units 06/27 12:00 Wireless DTC: 688 orders 3140 lines 3140 units 06/27 13:00 Wireless DTC: 128 orders 540 lines 541 units 06/27 14:00 Wireless DTC: 535 orders 2729 lines 2731 units 06/27 15:00 Wireless DTC: 491 orders 2379 lines 2380 units 06/27 16:00 Wireless DTC: 250 orders 1290 lines 1292 units 06/27 17:00 Wireless DTC: 705 orders 3451 lines 3452 units 06/27 18:00 Wireless DTC: 606 orders 3182 lines 3183 units 06/27 19:00 Wireless DTC: 396 orders 1878 lines 1886 units 06/27 20:00 Wireless DTC: 599 orders 2923 lines 2925 units 06/27 21:00 Wireless DTC: 428 orders 2056 lines 2058 units 06/27 22:00 Wireless DTC: 508 orders 2709 lines 2731 units 06/27 23:00 Wireless DTC: 484 orders 2773 lines 2768 units 06/28 04:00 Wireless DTC: 41 orders 241 lines 239 units 06/27 08:00 DSL DTC: 23 orders 271 lines 287 units 06/27 09:00 DSL DTC: 44 orders 415 lines 423 units 06/27 10:00 DSL DTC: 100 orders 1036 lines 1040 units 06/27 11:00 DSL DTC: 61 orders 549 lines 520 units 06/27 12:00 DSL DTC: 82 orders 625 lines 575 units 06/27 13:00 DSL DTC: 61 orders 427 lines 404 units 06/27 14:00 DSL DTC: 85 orders 748 lines 708 units 06/27 15:00 DSL DTC: 39 orders 318 lines 316 units 06/27 17:00 DSL DTC: 60 orders 527 lines 561 units 06/27 18:00 DSL DTC: 61 orders 515 lines 545 units 06/27 19:00 DSL DTC: 44 orders 334 lines 338 units 06/27 20:00 DSL DTC: 64 orders 522 lines 516 units 06/27 21:00 DSL DTC: 26 orders 178 lines 170 units 06/27 22:00 DSL DTC: 84 orders 721 lines 690 units 06/27 23:00 DSL DTC: 224 orders 1947 lines 1931 units 06/28 04:00 DSL DTC: 7 orders 54 lines 47 units 06/27 07:00 UVERSE DTC: 12 orders 73 lines 49 units 06/27 08:00 UVERSE DTC: 241 orders 1779 lines 1812 units 06/27 09:00 UVERSE DTC: 303 orders 1457 lines 1338 units 06/27 10:00 UVERSE DTC: 673 orders 3171 lines 2850 units 06/27 11:00 UVERSE DTC: 278 orders 1884 lines 1903 units 06/27 12:00 UVERSE DTC: 396 orders 2679 lines 2914 units 06/27 13:00 UVERSE DTC: 240 orders 963 lines 842 units 06/27 14:00 UVERSE DTC: 307 orders 2002 lines 2023 units 06/27 15:00 UVERSE DTC: 275 orders 1740 lines 1800 units 06/27 16:00 UVERSE DTC: 96 orders 377 lines 319 units 06/27 17:00 UVERSE DTC: 226 orders 1542 lines 1347 units 06/27 18:00 UVERSE DTC: 372 orders 1999 lines 1505 units 06/27 19:00 UVERSE DTC: 190 orders 1283 lines 1318 units 06/27 20:00 UVERSE DTC: 302 orders 1824 lines 1476 units 06/27 21:00 UVERSE DTC: 216 orders 1152 lines 892 units 06/27 22:00 UVERSE DTC: 309 orders 1827 lines 1647 units 06/27 23:00 UVERSE DTC: 1524 orders 7995 lines 7254 units 06/28 04:00 UVERSE DTC: 49 orders 474 lines 479 units 06/27 07:00 Wireless BULK: 53 orders 149 lines 266 units 06/27 08:00 Wireless BULK: 314 orders 1437 lines 4789 units 06/27 09:00 Wireless BULK: 52 orders 268 lines 856 units 06/27 10:00 Wireless BULK: 92 orders 295 lines 1033 units 06/27 11:00 Wireless BULK: 174 orders 749 lines 2757 units 06/27 12:00 Wireless BULK: 42 orders 345 lines 884 units 06/27 13:00 Wireless BULK: 260 orders 5481 lines 19102 units 06/27 14:00 Wireless BULK: 99 orders 1854 lines 6537 units 06/27 15:00 Wireless BULK: 64 orders 486 lines 1263 units 06/27 16:00 Wireless BULK: 46 orders 559 lines 1716 units 06/27 17:00 Wireless BULK: 120 orders 1296 lines 4535 units 06/27 18:00 Wireless BULK: 99 orders 1593 lines 5831 units 06/27 19:00 Wireless BULK: 246 orders 1458 lines 6340 units 06/27 20:00 Wireless BULK: 315 orders 1066 lines 4995 units 06/27 21:00 Wireless BULK: 381 orders 2322 lines 9580 units 06/27 22:00 Wireless BULK: 387 orders 2404 lines 9180 units 06/27 23:00 Wireless BULK: 394 orders 2659 lines 10226 units 06/28 00:00 Wireless BULK: 661 orders 3064 lines 11606 units 06/28 01:00 Wireless BULK: 149 orders 2639 lines 31876 units 06/28 02:00 Wireless BULK: 28 orders 201 lines 748 units 06/28 03:00 Wireless BULK: 22 orders 472 lines 1580 units 06/28 04:00 Wireless BULK: 18 orders 369 lines 1569 units 06/27 12:00 DSL LFO (BULK): 3 orders 3 lines 144 units 06/27 13:00 DSL LFO (BULK): 6 orders 6 lines 252 units 06/27 14:00 DSL LFO (BULK): 4 orders 4 lines 168 units 06/27 15:00 DSL LFO (BULK): 14 orders 14 lines 600 units 06/27 17:00 DSL LFO (BULK): 5 orders 6 lines 139 units 06/27 18:00 DSL LFO (BULK): 1 orders 2 lines 19 units
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
D Create a macro in Outlook to run a rule Outlook VBA and Custom Forms 32
S Outlook 365 Help me create a Macro to make some received emails into tasks? Outlook VBA and Custom Forms 1
A Outlook macro to create search folder with mail categories as criteria Outlook VBA and Custom Forms 3
Tanja Östrand Outlook 2016 - Create Macro button to add text in Subject Outlook VBA and Custom Forms 1
A Create Macro for hyperlink(email) in message body Outlook VBA and Custom Forms 9
L Macro Create Contact and Save Using Outlook 2
L Macro Create Contact and Save Using Outlook 8
S Macro to create notification emails Using Outlook 1
N Macro to create task Using Outlook 1
S Macro to create a new folder with subject line as the folder name Using Outlook 2
P Please Help me Create a Macro ! Using Outlook 2
S Macro to create a new contact, 2 appointments, and a task Using Outlook 1
M How to Create Macro in Visual Basic to add Contacts from Personal Folder Using Outlook 4
R How do I create a macro to put text in certain emails? Outlook VBA and Custom Forms 1
N How Can I create an Outlook Macro to import calendar? Outlook VBA and Custom Forms 1
P How do I create a macro to add contacts from email messages? Outlook VBA and Custom Forms 1
J Macro to create folder in PST file Outlook VBA and Custom Forms 4
G Macro: Create New Message and Auto populate To Field Outlook VBA and Custom Forms 5
S How to create a macro to insert a signature in Outlook 2007 Outlook VBA and Custom Forms 1
X Custom icon (not from Office 365) for a macro in Outlook Outlook VBA and Custom Forms 1
X Run macro automatically when a mail appears in the sent folder Using Outlook 5
mrrobski68 Issue with Find messages in a conversation macro Outlook VBA and Custom Forms 1
G Creating Macro to scrape emails from calendar invite body Outlook VBA and Custom Forms 6
M Use Macro to change account settings Outlook VBA and Custom Forms 0
J Macro to Reply to Emails w/ Template Outlook VBA and Custom Forms 3
C Outlook - Macro to block senders domain - Macro Fix Outlook VBA and Custom Forms 1
Witzker Outlook 2019 Macro to seach in all contact Folders for marked Email Adress Outlook VBA and Custom Forms 1
S macro error 4605 Outlook VBA and Custom Forms 0
A Macro Mail Alert Using Outlook 4
J Outlook 365 Outlook Macro to Sort emails by column "Received" to view the latest email received Outlook VBA and Custom Forms 0
J Macro to send email as alias Outlook VBA and Custom Forms 0
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Macro GoTo user defined search folder Outlook VBA and Custom Forms 6
D Outlook 2016 Creating an outlook Macro to select and approve Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Macro to send an Email Template from User Defined Contact Form Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Macro to check Cursor & Focus position Outlook VBA and Custom Forms 8
V Macro to mark email with a Category Outlook VBA and Custom Forms 4
M Outlook 2019 Macro not working Outlook VBA and Custom Forms 0
Geldner Send / Receive a particular group via macro or single keypress Using Outlook 1
D Auto Remove [EXTERNAL] from subject - Issue with Macro Using Outlook 21
V Macro to count flagged messages? Using Outlook 2
sophievldn Looking for a macro that moves completed items from subfolders to other subfolder Outlook VBA and Custom Forms 7
S Outlook Macro for [Date][Subject] Using Outlook 1
E Outlook - Macro - send list of Tasks which are not finished Outlook VBA and Custom Forms 3
E Macro to block senders domain Outlook VBA and Custom Forms 1
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
N VBA Macro To Save Emails Outlook VBA and Custom Forms 1
N Line to move origEmail to subfolder within a reply macro Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Macro to answer a mail with attachments Outlook VBA and Custom Forms 2
A Outlook 2016 Macro to Reply, ReplyAll, or Forward(but with composing new email) Outlook VBA and Custom Forms 0

Similar threads

Back
Top