Hello!

I am trying to set up a mail merge from a database. I wasn't sure whether to post here or in the macro thread, but I opted for here because maybe a macro isn't the best way to accomplish what I need. I read a lot of Macropod's responses on various websites, and he has helped me with some other problems I was facing.

But in this case, I have a field pulled from a database that looks roughly like this.

^Total^Fall^Spring
Award 1^$2,000
Award 2-Award^$1,000
Award 3 etc.^$500

I then made a macro that pulls apart this field and formats it as a table without borders. (Minus the underscores)
____________________Total_______Fall_______Spring
Award 1_____________$2,000_____$1000.00___$1000.00
Award 2-Award_______$1,000_____$500.00____$500.00
Award 3 etc._________$500_______$250.00____$250.00
Total_______________$3500.00____$1750.00___$1750.0 0

All of this works great. The problem is, that when the mail merge field is unlinked, it overwrites all records with the first record's data. So all of the letters besides the first will display incorrect information. I'm leaning towards a table if possible, because as you can see, my macro performs some calculations with this data. It will be easiest to access in a table.

Is there any way to convert the text of the field to a table without unlinking it?
Or, is there a better way to process this issue?

Thanks in advance.