Link to home
Create AccountLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access VBA Email all tables as Excel spreadsheets


What Access VBA code would I use to automatically email all Access tables as Excel spreadsheets
via Outlook without the user being able to alter the data. So I want the emails to fire off straight away.

Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Any data when it has been separated from its source is open to amendment unless it is protected in some way.

I don't know how you do it but would suggest you create a Front End Viewer that you distribute to users. I believe a Front End Viewer enables users to view the data and/or reports without having access to the actual data so can't amend it.
Avatar of Bill Prew
Bill Prew

Do you mean you don't want them to alter the data in Access, or in the email?

If the latter, and you are attaching it as an Excel workbook, then you could protect that against modification with a password, etc.


Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Murray Brown


Hi Scott. Yes that is exactly what I needed.
Thank you very much