How to add input box for require record to mail?

That may be because there's an error in my edit of your Const strQry String. As I said, SQL is not my forte. Try the code with your Const strQry String from post #17.