How to Mail Merge in LibreOffice Writer

Поділитися
Вставка
  • Опубліковано 16 жов 2024
  • In this tutorial you will learn how to mail merge in LibreOffice Writer.
    Support me with your amazon purchases: melcompton.com....
    Check out these programs I use for UA-cam
    Bluehost discount: melcompton.com....
    Canva Pro Trial: melcompton.com....
    Adobe: melcompton.com...
    Filmora: melcompton.com....
    Follow me on social media:
    Facebook: / therealmelco. .
    Twitter: @melissaecompton
    Instagram: @melissaacompton
    LinkedIn: / melissa-c. .
    This description contains affiliate links and I may be paid a small commission should you purchase using these links.
    #melissacompton #libreoffice #mailmerge

КОМЕНТАРІ • 29

  • @gjsemler
    @gjsemler 4 місяці тому +1

    Mel, excellent presentation. Tx for your patience and due diligence in preparing this video. Great Work

    • @MelCompton
      @MelCompton  Місяць тому

      Thank you! Glad it was helpful!

  • @andre.79
    @andre.79 7 місяців тому +1

    Nice! But how to send each of these letters to their respective e-mail address? Do you use Thunderbird's mail merge or you can send them through libreoffice?
    Thanks in advance and for sharing your content 🙏🏻

  • @robertdocherty6127
    @robertdocherty6127 Рік тому +2

    Thank you for this very easy to follow tutorial.
    You have a new subscriber here.
    I wish you every success with the channel.

    • @MelCompton
      @MelCompton  Рік тому

      Thank you! I'm glad it helped!

  • @edilantieri5490
    @edilantieri5490 Рік тому

    Hi Melissa, interesting video. I have a question and I hope you can help me, maybe you have already made a video to suggest. I would like to use the "conditional text" procedure which is similar to setting the mail merge rules in Word Office (Do you know Word? I think so). Then set a rule on the email that tells me: "if the field in Calc is equal to "A" then write (in the email) OK otherwise "NOT OK" avoiding adding columns on a calc sheet that already has lots of them. Thanks again for your attention.

  • @zakesduma3639
    @zakesduma3639 Рік тому +1

    Thank very much! that was well simplified, what a good teacher!

    • @MelCompton
      @MelCompton  Рік тому

      Thank you! I'm glad it helped!

  • @MX51959
    @MX51959 2 місяці тому

    Hi Melissa thank you so much for this tutorial, you are so easy to understand. John from Australia.

    • @MelCompton
      @MelCompton  Місяць тому

      Thank you! Glad it was helpful!

  • @JudiCampbell-ts2ln
    @JudiCampbell-ts2ln 6 місяців тому

    Thank you for your easy to follow instructions.

  • @dsongwriter9784
    @dsongwriter9784 8 місяців тому +1

    My problem using mail merge is it doesn't remember the database the next time I open the document and have to go through the multiple steps to reconnect. Is there a way to make the connection automatic?

  • @1234TokyoJohn
    @1234TokyoJohn 11 місяців тому

    So clear. Really good, thumbs up!

  • @WJHandyDad
    @WJHandyDad 5 місяців тому

    is there a way to do a mail merge document that isn't just name, address, phone? With Word I can do merge documents with all sorts of fields

    • @SoCalBruce
      @SoCalBruce 16 днів тому

      I have the same question. Did you get an answer? I am thinking about quitting word and changing to Libreoffice. But I need to mail merge for my forms with a lot of data other than name, address, company name, etc.

    • @WJHandyDad
      @WJHandyDad 15 днів тому

      @@SoCalBruce I ended up buying MS Office 2019 because I could never find anything on LibreOffice doing a mail merge like Office does. There was quite a learning curve going from Office 2008 to Office 2019 but now that I'm getting the hang of it, it's working out OK

  • @johnklansek8898
    @johnklansek8898 Рік тому

    Hi Mel great little video how do you insert merge fields from just a txt file when I view the datasource its all in a line and when I try to drag and drop all the merge fields are loaded what am I missing

  • @alanpugh3057
    @alanpugh3057 8 місяців тому

    Can you edit the four 'user' labels during or after merging the spreadsheet data

  • @whynnot
    @whynnot Рік тому

    Really helpful. Thanks a lot.

  • @rashabba7846
    @rashabba7846 Рік тому

    Thank you Melissa, can you please also show how to send attachments with mail merge

  • @korehan1850
    @korehan1850 Рік тому

    Great Video, thank you

  • @peterc2248
    @peterc2248 Рік тому

    Very useful information. Does it just relate to just address data though? I have a LibreOffice Base database that contains data about burials and I need to produce various documents from that data. Can I specify individual custom fields? And by the way, its nice to see such a charming presenter with a lovely silky voice instead of the usual loud, in your face Americans (but I'm a Brit so very reserved of course :-))

    • @SoCalBruce
      @SoCalBruce 16 днів тому

      Did you get an answer to your question? I have the same need to add a lot of other fields to merge from a spreadsheet.

  • @GreenGlowVegan
    @GreenGlowVegan Місяць тому +1

    Thank you❤

    • @MelCompton
      @MelCompton  Місяць тому

      You're welcome 😊 Glad it helped!

  • @test-kf2zv
    @test-kf2zv Рік тому

    What happens if it can't be loaded?

  • @KLittle35
    @KLittle35 9 місяців тому

    Keep up the good work

  • @Toannguyen10395
    @Toannguyen10395 8 місяців тому

    thanks!