F
Fanny
Dear Helpers,
I am using MS 2000 outlook. My company stores all the products and service
guidelines in the public folder located at outlook. Every week there are
updates of products and service guidelines where I need to check for those
guidelines to support the sales teams and back office. The structure is as
follows:
+Public Folder
+Products Folder
+Product 100
+Product 101
+Product 102…….
+Services Folder
+Service 100
+Service 101
+Service 102……
Each product or service is made into a new subfolder and there further
subfolders when there are product modification/appendix, i.e. 101a and 101b
As there are too many products, I set up an access file which link to each
folder.
1) Set up a “make table query†from the first folder (one time only)
2) create “ append query†to each of the subsequent folders and
3) Update the macro
so that a new table containing all the data fields such as
a) Source
(Manually insert a new field for the folder name in the “make table
query†and each “append query†for finding the source folder)
b) subject,
c) body text of the product/service (the body shows the sales region and
production date)
d) modification date etc
The primary goal is the selected query made on the new table by inputting
date or sales team name or region to ease the searching purposes.
The difficulties are that the new folders and subfolders (i.e. new products
and services) are increased and modified regularly that it is a very tedious
and time consuming steps to link the folders, create new append queries and
update the macro. Secondly, it is impossible to retrieve directly via
folders and subfolders.
I want to find if there are any method to link the folders automatically or
any suggestion to modify my workflow.
Thanks for your help.
Fanny
I am using MS 2000 outlook. My company stores all the products and service
guidelines in the public folder located at outlook. Every week there are
updates of products and service guidelines where I need to check for those
guidelines to support the sales teams and back office. The structure is as
follows:
+Public Folder
+Products Folder
+Product 100
+Product 101
+Product 102…….
+Services Folder
+Service 100
+Service 101
+Service 102……
Each product or service is made into a new subfolder and there further
subfolders when there are product modification/appendix, i.e. 101a and 101b
As there are too many products, I set up an access file which link to each
folder.
1) Set up a “make table query†from the first folder (one time only)
2) create “ append query†to each of the subsequent folders and
3) Update the macro
so that a new table containing all the data fields such as
a) Source
(Manually insert a new field for the folder name in the “make table
query†and each “append query†for finding the source folder)
b) subject,
c) body text of the product/service (the body shows the sales region and
production date)
d) modification date etc
The primary goal is the selected query made on the new table by inputting
date or sales team name or region to ease the searching purposes.
The difficulties are that the new folders and subfolders (i.e. new products
and services) are increased and modified regularly that it is a very tedious
and time consuming steps to link the folders, create new append queries and
update the macro. Secondly, it is impossible to retrieve directly via
folders and subfolders.
I want to find if there are any method to link the folders automatically or
any suggestion to modify my workflow.
Thanks for your help.
Fanny