If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do i email an individual report from a form?
I've tried this like 20 times today to no avail. I keep getting all my
purchase orders in the pdf format instead of just the one record. Everything else works as far as opening up Outlook and attaching the pdf file, but selecting just the last record I was working on in a form isn't cutting it. I see a lot of the VB command lines in other areas of this forum, but I'm not that savvy to writing code. Any ideas on what's up? Using Access 2007. Thanks! "solsk" wrote: Thanks Mike that seems to be working a treat! Cheers "Mike" wrote: solsk wrote: I have setup a Macro to send reports to outlook from a command button on a form that is linked to the report. However, the attachment always contains all reports, i would like it to just email the current report ( a purchase order) or perhaps enable to enter the purchase order number which i want to send. Any ideas? Hi You could also try this Create an "open form" macro and insert it before the "send object" macro. Report name is your reports name which should be in the list . View is. Print preview. Leave the. filter. blank. Where condition is, [your field name]=[Forms]![Your form name]![your field name] Put this macro into the on click part of your command button it should then open the report for the record on display generating the attachment to email all you need to do then is type in the reciepient. I am using access 2000 and it works perfectly. Please reply to this news group if you have any joy Good luck Mike |
#2
|
|||
|
|||
How do i email an individual report from a form?
Mark,
How do you print the report? Button on a form? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Mark" wrote in message ... I've tried this like 20 times today to no avail. I keep getting all my purchase orders in the pdf format instead of just the one record. Everything else works as far as opening up Outlook and attaching the pdf file, but selecting just the last record I was working on in a form isn't cutting it. I see a lot of the VB command lines in other areas of this forum, but I'm not that savvy to writing code. Any ideas on what's up? Using Access 2007. Thanks! "solsk" wrote: Thanks Mike that seems to be working a treat! Cheers "Mike" wrote: solsk wrote: I have setup a Macro to send reports to outlook from a command button on a form that is linked to the report. However, the attachment always contains all reports, i would like it to just email the current report ( a purchase order) or perhaps enable to enter the purchase order number which i want to send. Any ideas? Hi You could also try this Create an "open form" macro and insert it before the "send object" macro. Report name is your reports name which should be in the list . View is. Print preview. Leave the. filter. blank. Where condition is, [your field name]=[Forms]![Your form name]![your field name] Put this macro into the on click part of your command button it should then open the report for the record on display generating the attachment to email all you need to do then is type in the reciepient. I am using access 2000 and it works perfectly. Please reply to this news group if you have any joy Good luck Mike |
Thread Tools | |
Display Modes | |
|
|