M
martyn
I have been trying unsuccesfully to solve this problem.
What happens is;
I recieve a email with a list of products that i need to
fix
Im not sure whether to use access or excel but when these
products are fixed i need to 'tick a box' or somehow mark
as fixed. At the end of the day i need to;
\sort the fixed and not fixed
\sort the products by supplier
\export the fixed products and email back to the spre-
sorted suppliers
\relist the not fixed products the next and every morning
until they are fixed.
I know how to sort by supplier.
i know how to export to email
I am struggling with the rest.
I recieve the email every morning, so if i import every
morning, will it not just overwrite everything from the
day before, thereby not leaving the unfixed products??
Any help appreciated.
What happens is;
I recieve a email with a list of products that i need to
fix
Im not sure whether to use access or excel but when these
products are fixed i need to 'tick a box' or somehow mark
as fixed. At the end of the day i need to;
\sort the fixed and not fixed
\sort the products by supplier
\export the fixed products and email back to the spre-
sorted suppliers
\relist the not fixed products the next and every morning
until they are fixed.
I know how to sort by supplier.
i know how to export to email
I am struggling with the rest.
I recieve the email every morning, so if i import every
morning, will it not just overwrite everything from the
day before, thereby not leaving the unfixed products??
Any help appreciated.