Forum Discussion
MS Access Email Report
No worries! We all started at the beginning!!!
2 Ways:
- Ctrl + G
- Atl + F11
What about using DLookUp()?
=Nz(DLookup("[EmailAddressColumnName]", "[TableWhereItMayBeFound]", "[YourCriteria]='SomeValue'"), "")
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