asked on Access VBA Email all tables as Excel spreadsheets
Hi
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.
Thanks
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.
Thanks
Microsoft AccessVBAMicrosoft ExcelMicrosoft Office
Last Comment
Murray Brown
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.
»bp
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi Scott. Yes that is exactly what I needed.
Thank you very much
Thank you very much
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.