Autmoating Access

S

Steven

I have an mdb that I use to create weekly status excel spreadsheets. The
spreadsheet has a preformatted summary page, which I have been requested to
place in the body of the email -- our blackberry users can not open the
spreadsheets.

I have been creating the email and using .Display on the Outlook object to
allow me to open the attachment and to a copy paste of the the summary sheet
before sending.

Is there a way that I can do a copy - paste from Acccess and keep the
formating?

Thanks!
 
Top