emailing a single page from report

[Lostsamoan]

I have a database that is strictly for generating and printing work orders. Our supervisors use it to print new work orders on the fly. normally that is fine. I have the Vb to print that specific work order

what I need to create is a VB that would allow other people to create a work order that would email it to the those supervisors. email addresses will always be the same. I just dont want to send the entire report. any help would be much appreciated

mahalo nui loa

 

[GinaWhipp]

Huh?

1. Do you mean you don't want to send the entire Work Order? I am guessing here but are the Work Orders more than one page and you only want to send page one?

2. Are you saying only Supervisors have the ability to create Work Orders? Is that because no one else has the database?

 

[Lostsamoan]

1. our work orders are only one page. it is not for customers. Because were are a manufactoring plant that makes food containers, we have audits that require documention that when problem arise that not only was the problem fixed but the place has been cleaned and in running order. supervisor will hand a work order to an employee to do a task. employee sign it when it has been completed and supervisor signs it after inspection. I use access instead of excel for this because by using the work order number (primary key), date issued, along with print date to show our paperwork is legit. We used to have blank forms but was informed that that wasnt
sufficient enough.
2. There is a main database that only I use. It is located on the plants network drive (O:\). All management have access to that drive. I created a secondary database that has linked tables to that main database. the secondary database is used only to create and print Work orders. once work order is completed, I input data to main database to close the work order.

 

[GinaWhipp]

Sorry for delay...

Okay, so I still don't get the problem. Maybe this is what you are looking for...
http://www.access-diva.com/vba16.html

Side note, not sure why you didn't split the database and give everyone their own Frontend but you really should consider doing that.