Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

use sendobject to email a report in excel

Status
Not open for further replies.

christak

MIS
Jul 14, 2003
20
US
I am using SendObject to send a report made in MS Access. I am sending it as an Excel spreadsheet. Everything works fine, but how can I format the spreadsheet? I would like to put gridlines around the text in excel.
I'm hoping someone can help me... Keep in mind, I DO NOT know code. I do all of my access work through query builders and wizards, etc. I know that is very sad, but it's true.
Thanks in advance!
 
If you name the excel sreadsheet the same name every time, you can go into the excel spreadsheet and set the page setup. Go to the sheet tab and check the gridline and Save. Then everytime the speadsheet is open the gridline will print out. I hope this will help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top