Form Or Report

[a10sgoddess]

I am using Access 2007. The database contains employees, their cell phone numbers and detailed charges per month. An e-mail is sent to each employee as an attachment, which is in pdf format. The e-mail text is generated from a form that getys updated monthly. The manager wants a chart to show in the e-mail. i've tried inserting an image into the e-mail form, and everything works in Design and Form view, but when I send the e-mail to myself, the chart disappears. I've attached a Snag-it of what I'm trying to do by putting the image into the text box. Can I group these two controls so the image will stay with the text? Thanks for your help.

[RuralGuy]

Have you tried adding two attachments to the email yet?

[a10sgoddess]

Thank you for the suggestion, but I did try to attach it. It wouldn't show when I e-mailed it to myself. Last month I just ended up putting a hyperlink in the body of the e-mail, but they had to actually click on the hyperlink. The manager really wants the chart to show. I'm not saying they are lazy, but having to click on a link that maybe only some of them care about is asking a lot from the others -- if they could just see the visual, it would really make my life easy. I tried the grouping the two, but the handle for the chart doesn't want to work now.

[RuralGuy]

What method do you use to create the PDF for the email? Have you made an Access Report for your chart yet?

[a10sgoddess]

I don't know how he made the pdf format. I can't tell by anything on the property sheet of either reports.

I have this code from the form
stDocName = "Cellphone Detail Report"
v_subject = Me.Txt_SubjectLine

' mychart = Me.Chart
v_message = Me.Txt_Message
For x = 1 To 200
v_email = Me.EmailID.Value
v_address = RTrim(v_email) & "@XXXX.com"
'v_address = "jpjc@XXXX.com"
DoCmd.SendObject acReport, stDocName, "PDF Format (*.pdf)", v_address, , , v_subject, v_message, 0
DoCmd.GoToRecord , , acNext

Next

There is no code is the report for me to see -- I hope I didn't mess it up.

I didn't make a report for the chart because how would I add it to the report that already goes out? I tried attaching it, but it didn't work.

[RuralGuy]

OK, you've found where the Report is created and you are using SendObject to send the email. Is the Report "Cellphone Detail Report" unique for each recipient of the email? If so, have you looked at adding a second page to this Report?

[a10sgoddess]

I'm going to try adding a second page. How do I do that, BTW -- I became brain dead yesterday afternoon because I had been looking and looking all afternoon for a solution to this problem without much success. Just a thought but maybe I can add another group to the report -- I'm not sure if I can do that since there is no place in the query where I can join the table to another table. I've attached a copy of the query. I didn't create this query -- I onl;y added the chart to the table. I'm not sure how the person that made this query makes it work. Thanks for your help! It is very, very much appreciated.

[RuralGuy]

Without a join in the query you get a cartesian product of the two tables; usually not what is wanted. Is the Report "Cellphone Detail Report" unique for each recipient of the email?

[a10sgoddess]

Yes, it is. Each employee gets a report of only their charges.

[RuralGuy]

Great! You should be able to add your chart to that report. If a 2nd page is required, there are tools to force another page. If necessary, you could create the chart in a separate report and then make it a SubReport of the 1st report. That might be the easiest way to go here.

[a10sgoddess]

Thanks so much for your help on the Access Form. I'm going to try that sub-report. I did manage to get a link in the e-mail form, but that's not really what I wanted -- that's not much different that putting the link in the body of the e-mail, and they still have to click on it. I really envisioned them seeing it,

Thanks so much for your help.
Jann

[RuralGuy]

Let us know of your progress and hopefully your success.