Plugin to merge JUsers info for mailing labels?

This forum is for general questions about extensions for Joomla! 3.x.

Moderators: pe7er, General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
BruceWRyan
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Mon Dec 14, 2015 8:13 pm

Plugin to merge JUsers info for mailing labels?

Post by BruceWRyan » Fri Oct 12, 2018 3:14 pm

Searching for a plugin that will take the Joomla User name and merge the address fields to create mailing labels. We are sending out old-school Thank You cards in the mail to all new people who sign up.

The newsletter component we use does not have a "print mailing label" option, nor does it capture the street address for export. We've been doing cut&paste from the admin Users page - which is rather tedious.

User avatar
AMurray
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3952
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Plugin to merge JUsers info for mailing labels?

Post by AMurray » Sat Oct 13, 2018 3:20 am

You should be able to export the database table #_contact_details which contains the name and addresses for the joomla users; you can export to Excel, then do the mail-merge with MS Word or whatever you are using.
("#" representing your own site's database prefix). You would need back-end access to the database in phpMyAdmin and it's a simple process.

However, you might be able to do the same thing with the various export tools in the JED - for example https://extensions.joomla.org/extension ... -csv-file/ (note this is a paid extension - there don't seem to be many that are free of charge).
Regards,
--------------------------------------------------------------
A Murray
Millennium Falcon - it's the ship that made the Kessel run in less than 12 parsecs! The fastest hunk of junk in the galaxy.

BruceWRyan
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Mon Dec 14, 2015 8:13 pm

Re: Plugin to merge JUsers info for mailing labels?

Post by BruceWRyan » Sat Oct 13, 2018 1:55 pm

Thank you. That was one of the solutions I looked at.


Post Reply

Return to “Extensions for Joomla! 3.x”