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
|
|||
|
|||
printing one form
How can I send a form through Outlook? When I try to send
it, it sends all 50,000. I only want to send the form showing on the screen. If I choose edit, select record and then send, it sends it but in a table setup. I want the form to show so it can be printed this way. Help. |
#2
|
|||
|
|||
printing one form
I'm not sure you can do that. I tried to do the same thing
but fail. there is a send mail function in access but sending the form wasn't an available format. i solved the problem by creating a report the looked just like the form and sent the report. i used this code attatch to a button lable "send mail". It will ask for a id to identify the record to be sent. Private Sub cmdSendeMail_Click() On Error GoTo Err_cmdSendeMail_Click Dim stDocName As String stDocName = "rptVMDForm" DoCmd.SendObject acReport, stDocName, "RichTextFormat (*.rtf)" Exit_cmdSendeMail_Click: Exit Sub Err_cmdSendeMail_Click: MsgBox Err.Description Resume Exit_cmdSendeMail_Click End Sub -----Original Message----- How can I send a form through Outlook? When I try to send it, it sends all 50,000. I only want to send the form showing on the screen. If I choose edit, select record and then send, it sends it but in a table setup. I want the form to show so it can be printed this way. Help. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Searching Records | Melissa Lambino | New Users | 6 | July 20th, 2004 04:51 AM |
repost: Printing out form + subform | Edm | Using Forms | 3 | July 7th, 2004 04:33 AM |
surely a form with a ListBox can be used in a query? | 1.156 | Running & Setting Up Queries | 14 | June 2nd, 2004 04:54 PM |
Limit Printing a Form on a Worksheet | Danny | Worksheet Functions | 2 | December 18th, 2003 12:12 AM |
printing form or a database like | jv | Worksheet Functions | 2 | November 2nd, 2003 03:33 PM |