Icon

How to Update Web Figures and Export Data Using Outlook and Excel

Learn the step-by-step process of updating web figures, exporting data to Excel, and managing daily breakdowns using Outlook and Excel macros.

By Adam Frost

In this guide, we'll learn how to update web figures and manage data using Microsoft Outlook and Excel. The process involves retrieving data from emails, updating spreadsheets with macros, and exporting information to Excel. We'll also cover how to prepare and send a summary email to specific recipients. This guide will help streamline your workflow and ensure accurate data management.

Let's get started

First, open Outlook.

1
Click here
Step #1: Click here

We search for the web figures with today's date.

2
Click on "Good Morning All Please"
Step #2: Click on "Good Morning All Please"

We will save the new web figures to the desktop.

3
Click here
Step #3: Click here
4
Click here
Step #4: Click here

Desktop.

5
Click on "Desktop"
Step #5: Click on "Desktop"

Save new figures.

6
Click on "Save"
Step #6: Click on "Save"
7
Click on "Yes"
Step #7: Click on "Yes"

Then, go to the website files folder.

8
Double-click here
Step #8: Double-click here

Load the WFupdate macro.

9
Double-click on "WF update macro"
Step #9: Double-click on "WF update macro"

Click on the WFupdate sheet.

10
Click on "WEB update"
Step #10: Click on "WEB update"

11
Click on "Click this button after get Data"
Step #11: Click on "Click this button after get Data"

Return to the PDF sheet.

12
Click on "PDF"
Step #12: Click on "PDF"

Click on "Data."

13
Click on "Data"
Step #13: Click on "Data"
14
Click on "Get Data"
Step #14: Click on "Get Data"

Retrieve data from the file.

15
Click on "From PDF"
Step #15: Click on "From PDF"

Open the PDF file on your desktop.

16
Click on "Desktop"
Step #16: Click on "Desktop"

Locate the new figures file.

17
Click on "new figures"
Step #17: Click on "new figures"
18
Click on "Import"
Step #18: Click on "Import"

Import. Click on table 001. Pages 1 to 2.

19
Click on "Table001"
Step #19: Click on "Table001"
20
Click here
Step #20: Click here

Load 2.

21
Click on "Load To ..."
Step #21: Click on "Load To ..."

It's an existing worksheet.

22
Click on "Existing worksheet :"
Step #22: Click on "Existing worksheet :"

Click the top corner of the existing worksheet.

23
Click here
Step #23: Click here
24
Click on "OK"
Step #24: Click on "OK"

Press OK, then go to the WFupdate sheet.

25
Click on "WEB update"
Step #25: Click on "WEB update"

Click the "Get Data" button.

26
Click here
Step #26: Click here
27
Click on "ок"
Step #27: Click on "ок"

Is that one done? Alright. Then, open an IP direct dashboard.

28
Right-click here
Step #28: Right-click here
29
Click on "031PDIRECTD.vpt"
Step #29: Click on "031PDIRECTD.vpt"

You load up the remaining orders.

30
Click on "..."
Step #30: Click on "..."

If the window doesn't appear, go to your taskbar and click here. Then press OK.

31
Click here
Step #31: Click here
32
Click on "OK"
Step #32: Click on "OK"

Then, go to File and select Export to Excel. Click Yes.

33
Click on "File"
Step #33: Click on "File"
34
Click on "Export"
Step #34: Click on "Export"
35
Click on "Yes"
Step #35: Click on "Yes"

Save the file to your desktop. Then close the window.

36
Click on "Save"
Step #36: Click on "Save"

Return to the website files folder.

You want to open "copy of the daily breakdown".

37
Double-click on "Copy of Daily Breakdown"
Step #37: Double-click on "Copy of Daily Breakdown"

Press the populate button. This loads the remaining orders from your desktop into the order sheet.

38
Click on "Populate"
Step #38: Click on "Populate"

We have 1, 2, 3. Do not include weekends. So, we have 0 orders of free working days.

39
Click on "Populate"
Step #39: Click on "Populate"

count back three days, not including today's date. For example, start from the 18th and count backwards

For March 13th, there are 0 quantities, 0 allocated, and 0 not allocated. We will leave all these as 0s for returns due to the new method we use. Now that's done.

.

40
Click on "0"
Step #40: Click on "0"

Go to Outlook. Then, go to Home and select New Email. Send it to Martin Waring, Ian Walsh, and Nick Smith The CC is DC web.

41
Click here
Step #41: Click here

The topic is web update.

42
Click on "Home"
Step #42: Click on "Home"
43
Click on "New Email"
Step #43: Click on "New Email"

.

44
Click on "DCweb@thedunegroup.com"
Step #44: Click on "DCweb@thedunegroup.com"

Okay, let's return to the WF update macro first.

First, copy this table

45
Click here
Step #45: Click here
46
Drag here
Step #46: Drag here
47
Right-click here
Step #47: Right-click here
48
Click here
Step #48: Click here
49
Click here
Step #49: Click here
50
Right-click here
Step #50: Right-click here
51
Click here
Step #51: Click here

Next, copy the second table from the daily breakdown

52
Click here
Step #52: Click here
53
Drag here
Step #53: Drag here
54
Right-click here
Step #54: Right-click here
55
Click here
Step #55: Click here
56
Click here
Step #56: Click here
57
Right-click here
Step #57: Right-click here
58
Step #58:
59
Click here
Step #59: Click here

How to Update Web Figures and Export Data Using Outlook and Excel