User ManualEmail Discussion Group User Guide SubscribeHow to compare your current membership (including names) to your mailing list(s)

How to compare your current membership (including names) to your mailing list(s)

If your membership database is out of sync with who is on your mailing list, this procedure will show you the differences.

If you have multiple lists, this command will compare your membership to all of your mailing lists.

You can upload a file that is an Excel spreadsheet, or a CSV (Comma Separated Value) file

How to reconcile your spreadsheet of members to our mailing lists

You can send in a list of your member's email address and names, separated by a comma.

joe@hotmail,Joe Smith

sally@aol.com,Sally Jones

sue@yahoo.com,Sue Ann Brown

etc

You can include any alternative email addresses that you store in your database

You can send in a list of your member's email address and names, separated by a comma.

joe@hotmail,joe@smith.com,Joe Smith

sally@aol.com,,Sally Jones

sue@yahoo.com,sueannbrown@gmail.com,Sue Ann Brown

Our system will return the name, along with the current email address they are subscribed as

So if your members have changed their email address on your mailing list, this report will show you their current email address.

The report will show you email addresses that are on your list, but not in your membership

This report will show you an audit trail of when members joined, unsubscribed, changed their email address, switched to the digest, etc.

You can do this from email or our web page.

Web Page Method

Click on Manage Subscribers

Click on Current List vs Your Spreadsheet

The spreadsheet must have at least one column that contains your member's email address.

You can have many additional columns of alternative email addresses for that member.

The last column can be their name or membership id or any other identifying data you store.

All columns except for the last column must contain email addresses or be blank.

Paste your list of current addresses in the box.

Select the Radio Button for Compare Current List To Your Spreadsheet Addresses And Names

Click on the button.

Your report will be mailed back to the moderator address you chose.

Email instructions

Send an email to your-list-name-moderator@mail-list.com

Password in the Subject Line.

COMPARENAME

in the first line of the body of the email

Send an email to your-list-name-moderator@mail-list.com

The first line of the body of the email must be the word COMPARENAME

The rest of the body of the email should be your list of email addresses and names, one email address per line.

After the email address, put a comma, and then their name and any other information you want.

You will receive an email report back, showing you the difference between your current roster, and who is on your list, on your digest, and on vacation.

You will receive an email report back, showing you the difference between your current roster, and who is on your list, on your digest, and on vacation.

In addition, you will receive a detailed report showing you the differences

The report is sent as an attachment in a TSV (Tab Separated Value) format.

Save the attachment to your Desktop.

Open the TSV file with Excel or any other spreadsheet program.

0 Comments

Add your comment

E-Mail me when someone replies to this comment