Word 365 MAIL MERGE 255 characters limitation when importing datas from Maria DB Database's Datasource

Question

Hi,

I have created a mail merge macro in VBA with word 365 using a mariab db 3.1.10 database's datasource.

The problem is fields which have a longtext type in maria db database are truncated to 255 characters in my word's document when i execute my macro.

Is there a way to resolve it please ?

Answer 1

@DIALLO Mouctar

Generally, the system sets the data type by inspecting the first record in the data source.
So please make sure that the first record (create a dummy one if necessary) contains more than 255 characters in the field that is being truncated.

If you have any updates, please post back.

Regards,
Erin

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.