I just got done bidding on an Access project that requires sending email via Outlook and generating some reports in Excel format.   I think to myself “no problem, I know the VBA for doing that”.   I win the contract and then the customer says:  “When you are done, we will just put it on Sharepoint where everyone can use it.”

From what I can gather from the forums – Access on Sharepoint does not support VBA.   Is there some other way I can send email via Outlook and generate Excel reports when the Access file is on Sharepoint?  

​I just got done bidding on an Access project that requires sending email via Outlook and generating some reports in Excel format.   I think to myself “no problem, I know the VBA for doing that”.   I win the contract and then the customer says:  “When you are done, we will just put it on Sharepoint where everyone can use it.” From what I can gather from the forums – Access on Sharepoint does not support VBA.   Is there some other way I can send email via Outlook and generate Excel reports when the Access file is on Sharepoint?    Read More

​