How to add supplemental data in an Email?

Hi,

Imagine we are a University that has 20 different Campus (Each with a different Location, of course). Our contact table has a field called "Campus".

We want to include in our emails the Location of the Student's Campus, but this "Location" is not a field of our Contact Table. We tried using a Lookup Table "Campus-Location" or a CDO Table "Campus-Location" with two fields: "Campus" and "Campus Location", but we are unable to use any of them in a Field Merge.

What is the correct way to do this? I know this should be simple, I just want to add in my Email a data value (Campus Location) that I don't have in my Contact Table given another data value (Campus) that have in my Contact Table, maybe I am missing something obvious.