email mail merge using multiple worksheets

[MeanGreenEagle]

Hi,

I have a data set with emails in colmn a and the corsesponding clubs they belong to in column b seperated by comas.

So it looks like
column A column B
abc@aol.com bsa,gsa,atj


So far I have got a mail merge to look like this:
Dear abc,

You belong to the email list of:

bsa,gsa,atj

_________________________________________________________________

BUT

it needs to read:

Dear abc,
you belong to the email list of:

bsa - boyscouts of america
gsa - girlscouts of america
atj - Americans that jog



I have a workbook that I have drilled down this MASSIVE list to. I also created a table on another worksheet with some 400 of the club acronyms in column A and the coresponding full name in column b.


I can arrange the data in any way nessecary to run a macro or acomplish this through the mail merge, although what I think I need can't be done with a simple mail merge.

 

[MeanGreenEagle]

Could the above be achieved with a vlookup or would translating multiple club acronyms to their full name, not work inside of a mail merge like that?