Skip to main content
Solved

Generate document from Employee file not working - 23R2

  • February 9, 2024
  • 10 replies
  • 201 views

Forum|alt.badge.img+7
  • Do Gooder (Partner)
  • 26 replies

Hi,

 

I tried to generate document from employee file, but it is not working correctly

Here are basic data:

  1. I generated mail merge template
  1. I created my own Word Template with macro from Help documentation ( see attachment PLATOVY_VYMER.zip)

    Public Sub DoMailMerge(sFile As String)

        ActiveDocument.MailMerge.OpenDataSource Name:=sFile, _         ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _         AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _         WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _         Format:=wdOpenFormatAuto, Connection:="", SQLStatement:="", SQLStatement1 _         :=""    With ActiveDocument.MailMerge         .Destination = wdSendToNewDocument         .MailAsAttachment = False         .MailAddressFieldName = ""         .MailSubject = ""         .SuppressBlankLines = True         With .DataSource             .FirstRecord = wdDefaultFirstRecord             .LastRecord = wdDefaultLastRecord         End With         .Execute Pause:=False     End With End Sub 

 

  1. I created my own word template definition. I specified full path to word template on my local PC.

 

  1. In Employee file I click on Generate document, select my template and click on Generate.

 

  1. Word file is open, I click Yes on message

 

but no data are fetched from application.

 

Are there some additional settings or is it a bug?

Thank for help

 

Romana

Best answer by Romana

Hello everybody,

 

issue with characters and dates should be resolved in these versions

23.1.22 - 23R1 SU22, 23.2.15 - 23R2 SU15, 24.1.9 - 24R1 SU9, 24.2.3 - 24R2 SU3, 25.1E.0 - 25R1 EA

 

Romana

10 replies

tokrcz
Sidekick (Customer)
Forum|alt.badge.img+3
  • Sidekick (Customer)
  • 8 replies
  • April 12, 2024

Hello Romana,

exactly the same issue - when Word is opened I get this message:

And when I click on “Ano”, no data filled into mail merge fields:

Regard

Tomas Krejza


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • 26 replies
  • April 12, 2024

Hi Tomáš,

 

RnD admited this situation as a bug and it should be fixed in 23R2 SU4.

I havent had a chance yet to test it, because I dont have access to db with this service update. I let you know then

Romana


tokrcz
Sidekick (Customer)
Forum|alt.badge.img+3
  • Sidekick (Customer)
  • 8 replies
  • April 12, 2024

Hello, we are on version 23.2.4 and problem is still there. 


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • 26 replies
  • April 12, 2024

Good to know. I am going to report it again.

Thank you 

 

R.


tokrcz
Sidekick (Customer)
Forum|alt.badge.img+3
  • Sidekick (Customer)
  • 8 replies
  • April 12, 2024

I was thinking about possible issue with select from table performed in Word mail merge - if there can be any security setting which needs to be done/changed. I don´t know. 


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • 26 replies
  • May 29, 2024

Hi @tokrcz,

according to RnD statement this issue will be fixed in 24.1.1 - 24R1 SU1,24.2E.0 - 24R2 EA.

R.


Forum|alt.badge.img+2
  • Do Gooder (Partner)
  • 1 reply
  • September 13, 2024

The error remains the same in version 24.1.3. and no data was fetched to the file.


jdlmartiv
Do Gooder (Partner)
Forum|alt.badge.img+2
  • Do Gooder (Partner)
  • 1 reply
  • December 10, 2024

The error remains the same in version 24.1.6 and no data was fetched to the file


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • 26 replies
  • December 10, 2024

Hello everybody,

 

I managed to generate word document in version 24.1.4. I attached instructions. But there is still issue with special characters such as ,,ľščí”, date format cannot be set either and also there is a problem that not only generated document is opened but also word template. I solve this issue with RnD.

I let you know, if there will be some progress.

 

Romana


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • 26 replies
  • Answer
  • January 10, 2025

Hello everybody,

 

issue with characters and dates should be resolved in these versions

23.1.22 - 23R1 SU22, 23.2.15 - 23R2 SU15, 24.1.9 - 24R1 SU9, 24.2.3 - 24R2 SU3, 25.1E.0 - 25R1 EA

 

Romana