Forum Discussion
Solved
MS Access Email Report
Hi I have a Form that I can email as a report. There is an email address on the report that is automatically used as the 'sent to' address within Outlook. Is it possible to lookup a cc email address ...
No worries! We all started at the beginning!!!
2 Ways:
- Ctrl + G
- Atl + F11
Daniel, Thanks for responding, i did try DLookUp after searching youtube for a solution but I have not been able to get it to work, I will try again using the above. Ill post an update of my progress.
Why not just use VBA and avoid all these headaches and limitations! Macros are just a pain to work with and are limiting, you are MUCH better served working with VBA directly.
I did do a few tests on my end and =Nz(DLookUp(), "") worked for me. I'd suggest testing it in the VBA Immediate Windows to ensure you have the proper names and it works, and then copy it into the Macro knowing that it is good.
Ill try this, I am probably making some very basic errors, Thanks