That's going to be a long and interesting TechHelp.

Thank you for your response.

I've worked with "String" functions before. When importing Outlook emails into Access, the Wizard of  Import works great. It delivers 4 short text fields and one long text field. The long text field is where the uniform templete data is returned as "Content" field name.

How do I set a long text field to a single vba variable? I error with DAO recordset > Dim longT as Long, LongT = rs!content.

Once I have the variable longT equal to one of the complete records of former email template , I should be able to work with the various access string functions. Then, in a new access table, set each field to a 75 length text field. In all, 17 or more short text fields.                

Thanks again for your response, Gilbert Alphin

I think Long is a long integer.  You need a string.

Thanks for the information, Long is "Long Integer". For now, I cannot find any information on Dim Lt as "Long Text".

Variables

Dim longText As String

There is a limit of about 2 billion (2^31) characters in VBA