Could someone or everyone help me in creating a module that is similar to the "SendObject" macro? I've created a database that extracts and manipulate data for my inventory managers. I then use the SendObject Macro to distribute the final table in an Excel format. This is a daily process and works perfectly. However, I want to format the spreadsheet layout before it emails it out. Is that possible? Unfortunately, don't know much about VB. Please help. I want to do the following with the spreadsheet.
-Add grid lines
-Center the data
-Bold the column headers
-Format print layout i.e. Center and title
Thanks
RookieDBO
-Add grid lines
-Center the data
-Bold the column headers
-Format print layout i.e. Center and title
Thanks
RookieDBO