text table

[slimjen1]

All, using 2010. Inherited a database that has a table to store text for a form letter in a report. For example:

txt1	txt2	txt3	txt4	txt5
I am please to inform you	that you have been 	selected to attend	the conference in Atlanta	Please assign you work

The report is designed as a letter using =txt1… and so on to create a form letter. Is there another way to do this without storing the data in these fields in a table? I thought able mail merge but don’t know how to set this up or is it even worth it over doing this the current way. Thanks in advance

 

[plog]

That seems really weird. Compared to the way it is implemented, mail merge is extremely simple. I wonder what the intentions of storing it in a table was for?

Are there forms that allow end users to edit that text so that its simple for them to change the form letter? Is there a menu system where users can select which form letter to send?

I vote mail merge--google it, you should be up and running in 10 minutes. But, I'm just concerned that you might be breaking something or eliminating some functionality by moving it to mail merge.

 

[slimjen1]

Thank you for replying. I have never worked with a letter set up in a report. The way this is working the parts of the letter is setup in different fields in the table i.e. text1, text2... The source is a query with the table and other data. the letter is set up using iif statements to determine which fields to use i.e. =text2..... Like I said; I never created a letter in a database and I was trying to find another way.