Trying to create an invoice from access and use oulook to email

[rrhistory]

I have an access database with information such as name, address, item buying, cost, qty etc. This was in excel originally, but I thought Access would be the better way to create the forms I need.

What I want to do is create an invoice that will combine items from one buyer and then allow me to email that invoice thru outlook.

MANY years ago I did programming in dbase--but for some reason I seem to be totally lost here. I have browsed the web, read two books and am still totally confused.

I would greatly appreciate your time in pointing me in the right direction.

THanks in advance.

[MMcCarthy]

I have an access database with information such as name, address, item buying, cost, qty etc. This was in excel originally, but I thought Access would be the better way to create the forms I need.

What I want to do is create an invoice that will combine items from one buyer and then allow me to email that invoice thru outlook.

MANY years ago I did programming in dbase--but for some reason I seem to be totally lost here. I have browsed the web, read two books and am still totally confused.

I would greatly appreciate your time in pointing me in the right direction.

THanks in advance.

The first thing you will need to do is to make sure your tables are structured correctly. Have a look at this tutorial and come back with any questions.

Normalisation and Table structures

Mary

[NeoPa]

When you do come back (please do), you should try to ask questions of more limited scope. Very few will want to answer a question of the structure :-
How do I do this project?

Individual parts though, where you get stuck, will probably receive more than adequate responses.