Mail merge and access

[Elain222]

Hi, could anyone teach me how to do this? Thanks in advance!

Here is the result of a query I have:

Person Email Product Amount Category
A A@hotmail.com Apple 10 Fruit
A A@hotmail.com Orange 20 Fruit
A A@hotmail.com Pen 30 Office
B B@hotmail.com Apple 15 Fruit
B B@hotmail.com Orange 25 Fruit
B B@hotmail.com Pen 35 Office
C C@hotmail.com Apple 18 Fruit
C C@hotmail.com Orange 28 Fruit
C C@hotmail.com Pen 38 Office

What I need to do is the develop a report, in a format like:

Person: A

Category
Fruit Amount Office Amount
Apple 10 Pen 30
Orange 20
Total 30 Total 30




Do this for A,B,and C and send the individual report in via email to them. To me it looks like a mail merge, but I don't know how to manipulate the data and put it into the layout. My real data has a lot of data, about 100 person, and about 60 product that falls into two categories. Is there anyway easy and fast way to do this? Please help! Thank you very much!

 

[Lightwave]

Hi there E,

The way I'd tackle it would be to set up a report in the format that you are wanting each individual to receive their information... Then you could have a button on a form that selected on the individual ID that way you could produce an individual's information specifically.

If its a one off I would save these as PDFs with their name and then e-mail appropriately.

I don't think without a bit of setting up there's a quick and easy way to do this.

M

 

[Elain222]

Hi, M

Thanks for your reply! I don't quite understand what you mean by "Then you could have a button on a form that selected on the individual ID that way you could produce an individual's information specifically". Could you explain a bit? I'm relatively new to Access and your help is highly appreciated!