Software Search
HELP/FAQs?

Got questions/problems? Take a look through our FAQs (frequently asked questions), or email us at: support@bigyellowkey.com. We shall do our best to get back to you promptly.

Want Discounts?

Are your prices for multiple domains too large? Are you trying to get licences for test domains but being asked to pay full cost? Don't worry; we can add test domains to your licences manually. Just purchase a single domain addon/upgrade for what it is that you need, and then email us about your situation regarding the remaining domains and we'll liaise with you over the options. email us at: support@bigyellowkey.com. We shall do our best to get back to you promptly. click here for more information regarding multiple domains, upgrades, and discount policies.

BigYellowKey News
(click here to view all BYK news)

Imminent: 4/1/2016 4:05:00 PM
BYZ Development Points have been changed
Click Here for details.
The new BYZ Development Points (BYZ192) replace all previous BYZ Points which are now no longer available.

Released: 4/1/2016 3:05:00 PM
BYZ Annual Pass Now Available!
Click Here for details.
The BYZ Annual Pass replaces the BYZ addon subscription service.

Released: 4/1/2016 2:05:00 PM
The BYZ Terms and Conditions have been changed.
Click Here for details.

Apologies, but online Payments are temporary unavailable as we are in the process of changing our payment gateway.
Please contact us if you wish to place an order and we will organize a manual payment process for you.
We hope/expect online payments to be available again soon.

NewsLetter (MailShot/MailList) Customer Export for VPASP - BYZ172

<< back to previous screen

Export the people who are signed up to your mail-list out to an excel file. Also allows you to export non-maillist customers (eg people who have bought certain products etc). (only compatible with VPASP V7)



NewsLetter (MailShot/MailList) Customer Export for VPASP - BYZ172
Latest version:01/21-APR-2011
From vendor:Big Yellow Zone
For Terms and Conditions, click here
Please do not purchase any BigYellowZone
products/services or request technical
support until you have read and agree with
the terms and conditions.
Price:£35.00
add to cart


Compatibility, Bundling, and Status Notes:
Compatible with VPASP V7 only.
Before installing, you must have installed:
BYZ038
BYZ036

This product includes:
BYZ038
BYZ036

Demos/Samples:
(click on a link below to see the corresponding demo/sample)
Parameters/Search Block
Results/Summary Block
Excel Output Sample
Where Clause Help Block


If you've got VPASP V7, and want to send bulk-emails, then you need to have this facility.

VPASP V7 actually has 2 tables to hold mail-list customers (the customers table, and the newsletter table), so if you use the generic vpasp export facility to export one of those but not the other then you'll miss people out, and if you export both then you'll get duplicates. Even if you only export one of the tables you can still get duplicates.

This addon will go through both tables, and export a unique set of email addresses (with the corresponding first/last names) to an excel file.

It also gives you the ability to specify additional criteria (for example, to get lists of customers who've bought certain products) so that you can generate a newsletter customer list excel file for a specific target audience.

This is currently only available for VPASP V7, but if you'd like it for older versions of VPASP then please let us know and we'll make it compatible with older versions if there's a demand for it.


Technical/Developer Information:
Comes with example "where clauses" on the screen to show you the kind of syntax you can use when specifying optional additional criteria.

Please note, this exports the relevant customer/mail-list email addresses, first and last names into an excel file, but it does NOT have functionality to actually create/send emails; it's assumed that you'd use the exported excel file that this module generates and import that excel file into your own mail-shot software.

The sql needed to pull out these lists is a lot more complex than it looks at first glance; take a look at The Results/Summary Block sample which shows you the actual query needed for this example and you'll realise that it's not a simple thing to achieve without this module doing it for you.

The actual column headings (and which columns to output) that it outputs to excel are easily changed so you can tweak those headings/columns depending on what your mailshot software expects for its headings etc.

It displays the sql statement used to get the list, so if your mailshot software allows you to specify sql statements (as opposed to just importing a list from an excel file) then you can copy/paste the statement that the Results Block shows into your mail software.


Terms and Conditions:
For terms, conditions, and licensing information for all BigYellowZone products/services, please click here.
Please do not purchase any BigYellowZone products/services or request technical support until you have read and agree with the terms and conditions.


Full Version History:
VerNo Version Date Release Notes
01 21-APR-2011 Initial version - NewsLetter (MailShot) Customer Export for VPASP