Recent content by jayhawker

Hi Mark K - thanks for the reply! I have compacted and repaired (several times). 40mb isn't a problem yet butbi have more tables to pull in and want to keep the size from getting out if hand. I don't understand why the file sizes from SAP are so large. Thanks again

Howdy, I am currently using Office 2016 and have an XL file that is 10 mb. When I import that file to Access the db is 40 mb. Any tips for reducing the size? Using a xlb extension gets me to 3 mb but I'd really like to use Access. I've tried importing and even used ADO and sent the file...

Hi all! Currently, I'm taking my unread emails, storing them in a table then sending any Excel files to a specified folder I've modified some code I found while surfing and it works great but I'd really like to send the attachment name and file path with the email recordset. It's been a long...

It works now and all I did was: 1 Change .Send to .Display 2 Ran code (Outlook popped up with my email information) 3 Change .Display back to .Send 4 Ran code and email was sent no issues WEIRDNESS!!!!!

Sorry. . Send

Currently, I'm using MS Office Professional Plus 2010 and Windows 8.1. This code worked just fine then I started getting the 287 Error (Application Defined error). This is pretty frustrating any thoughts on how I can get it to work consistently????? Thank you in advance!! Function...