Page 1 of 1

[Solved] Access2Base bug in DoCmd.SendObject?

Posted: Sat Aug 20, 2016 6:53 pm
by inizul
It seems that the function does not recognize the parameter 'MessageText'

Code: Select all

Sub IRP_EnviarPDF
  Const acSendForm = 2
  Const acFormatPDF = "writer_pdf_Export"
  Dim sPara as string
  Dim sCc as String
  Dim sBcc as String
  Dim sMensaje as string
  Dim sAsunto as string
  'msgbox "Se enviará el informe por correo"
  sPara="nadie@gmail.com"
  sCc="nada@gmail.com"
  sBcc="tampoco@gmail.com"
  sAsunto= "Empresa: Informe de rechazo a proveedor"
  sMensaje= "Estimado proveedor." & chr(13) & "En su envío hemos encontrado un problema que nos obliga a rechazar el material"

  DoCmd.SendObject(acSendForm,"InformeRechazoProveedor",acFormatPDF,sPara,sCc,sBcc,sAsunto,sMensaje,True)
 'DoCmd.SendObject (ObjectType,         ObjectName,        OutputFormat, To, Cc,  Bcc,Subject,MessageText,EditMessage, TemplateFile)
End sub
This code work well: It open Thunderbird correctly but the MessageText is missing (see atached image: email.png)

Re: Access2Base bug in DoCmd.SendObject?

Posted: Mon Aug 22, 2016 1:03 pm
by JPL
Hi Inizul,

it is not a bug in Access2Base but a limitation of LibreOffice.

Have a look at the remarks in http://www.access2base.com/access2base.html#SendObject.
The by LO proposed interfaces do not provide the simultaneous sending of a body and an attachment ... :(

I can nevertheless understand your frustration.

Have a nice day.
JPL

Re: Access2Base bug in DoCmd.SendObject?

Posted: Mon Aug 22, 2016 5:44 pm
by inizul
Ups!!

Sorry for not correctly read the documentation :oops:

Thanks for the clarification.