Using Memo Field

[Idris]

Dear Friends

Something thats very important has just put me on halt i mean a mail merge feature that I want to use from MS Word into MS Access.

I have an application for School on MS Access - all the Class teachers have the access to their class student and subsiqently they login and feed in the scores/marks achived by the student.

Now the Principal has requested the class teachers to draft a individual letters to the students on the system. Well, thats also done using MEMO field but inbetween the teachers have requested to use the marks scored from the data fields while the letters have been drafted using memo fields or is there a way i can call the data table from MS ACCESS in MS WORD and do the drafting there

or HOW do I do it? - please suggest the best option to start the process

 

[statsman]

I would do it the other way around.
Create a query in access that contains the data that will be included in the letter.
Create the letter in Word and use mail merge to insert the fields into the letter.

I would tend to stay away from memo fields in this context as they are of varying length and would screw up the letter.

 

[Idris]

Thanks stats

I know that - but bcoz of the teacher with little working experience and to sumup the fast action the entire action is now required the way process works - BUT never the less I did manage to create my on Mergemail simple features and now its on production.