Headless mail merge
sos
sos at pmg.be
Thu Apr 7 10:18:10 UTC 2022
Hallo,
I can send the macro's for mailmerge (email & print) starting from
selected variable data in the Beamer (Datasource Browser) and using a
writer document as template
Greetz
Fernand
On 4/7/2022 9:38 AM, mcmurchy1917techy wrote:
>
> Hi Marco
>
> I have a Base application with forms. On one form I press a button
> which then performs a macro which executes a mailmerge
>
> The macro works out
>
> * what query to source the data dependent on which button has been
> pressed
> * where to send the output dependent on which button has been pressed
>
> If your script calls LO headless the macro could pick up instructions
> from data created by the script.
>
> Is this any help?
>
> Alex
>
>
> On 06/04/2022 21:50, Andrew Pitonyak wrote:
>> The first step is always do it without a script until you like the
>> result. Then you try to automate it.
>>
>> I did it a few times many years ago and do not remember the process.
>>
>> Get BlueMail for Android <https://bluemail.me>
>> On Apr 6, 2022, at 3:37 PM, Marco Marinello <lists at marcomarinello.it>
>> wrote:
>>
>> Hi Andew,
>>
>>
>> thank you for your answer. I'll take a look at the links you pointed to.
>>
>> The idea is, starting from a template in odt/doc/docx, to "fill in the
>> gaps" and save the filled document. Is there any other way rather than
>> mail merge?
>>
>>
>> All the best,
>>
>> Marco
>>
>>
>> Il 06/04/22 18:19, Andrew Pitonyak ha scritto:
>>
>> I had planned on documenting how to do this some years back
>> and AndrewBase.odt, and my only notes say that I should
>> document the new e-mail merge API released in OpenOffice.org
>> <http://OpenOffice.org> version 2.01; that was a long time
>> ago. I generally do not have reason to use mailmerge, but did
>> you want to send something by email or to print? Someone
>> posted a question about using mail merge with UNO in Basic
>> here:
>> https://ask.libreoffice.org/t/syntax-for-using-spreadsheet-as-data-source-in-emailmerge-macro/24831
>> From my perspective, the fact that they used the
>> server com.sun.star.text.MailMerge is useful in that it
>> provides a pointer to the service to look at. Another request
>> for help here:
>> https://forum.openoffice.org/en/forum/viewtopic.php?f=20&t=59312
>> No answer; sadly. In AndrewMacro.odt, there is an example
>> that merges a bunch of documents from a directory into a
>> single document and it is listed as being related to "mail
>> merge", so I assume that somebody had run a mail merge and
>> this processes created many documents. But again, I have not
>> run a mail merge in many years. On Wednesday, April 06, 2022
>> 06:47 EDT, Marco Marinello <lists at marcomarinello.it> wrote:
>>
>> Hi all, what's the easiest way to perform a mail-merge
>> with libreoffice by passing arguments from an automated
>> script? Should I use UNO? Do you have any reference?
>> Thanks in advance, Best, Marco
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20220407/c3e3a16d/attachment.htm>
More information about the LibreOffice
mailing list