What code is supposed to do this? You do not have code referencing either of these tables. You are filling in a variable with SQL for q_Tab_2222, but you don't do anything with this code.The email is intended to show the details of table "tbl_Dispatch" and "tbl_Summary" in the body of the email.
I'd advise coming up with a naming convention also. The name "q_Tab_2222" is pretty meaningless. Same with "frm_email_5_2" or "frm_entry_3bc".
You also have a "Tbl_Entry_Date" that seems to only hold a single date and an autonumber key. This does seem rather pointless as you would normally store the date in a file rather than a pointer to a date.
You will want to read up on data normalization. Tbl_Dispatch seems to be intended to hold references to 6 locations. This will become very problematic the first time you have a seventh location you will need to deal with. Seems like it should have those location in a child record. Same with "Tbl_test", though I've no idea what it would be used for.