Calling files stored in database?...

[budgy]

Hi I really hope some one can help me out here.

Here the outline of the situation. Every Friday evening I get sent a load of press adverts, which I have to put on the Intranet. This will involve detaching the ads, renaming them, adding them to the site with the Name of the paper, the date, and the organisation they belong to. What I want to know is if there is a more automated way of doing this. I was thinking weather I could detach and drop the ads into a folder and get a Access database connection to the press ads page. Which in-turn would allow me to insert the ads for the last seven days, yet keep a account of all ads which can be a called upon, via perhaps the use of a search function. This is just one idea I have had, are there any other ways I could make this mundane job easier?..


All your suggestions and feedback will be much appreciated.

Thanks in Advance

Budgy



"He that asks a question is a fool for a moment, he that never asks a question is a fool all his life

 

[KenReay]

Hi

You could even automate the detaching of the adverts, by using Access to create an instance of Outlook, you could scan the inbox, detach the adverts and store them in a folder etc all using automation code

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[budgy]

Hey KenReay,

We use lotusNotes here, and not outlook do u have any resources that would me in the automation process?

Thanks

"He that asks a question is a fool for a moment, he that never asks a question is a fool all his life

 

[KenReay]

Hi

Have not done anything that clever with Access/Lotus Notes, but try

http://www.granite.ab.ca/accsmstr.htm

there maybe something ther eto help you

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK