Hi Mathew

I can help - a bit...

I have used this simple template with success, so far:-

(You can get the role opt-in module from snowcovered, but apart from that, this will work with the standard newsletter module in DNN4x)

IMHO You wouldn't want to include their DNN password in a newsletter.  (I did generate passwords for their mail accounts based on name Membership number and postcode, then I bulk registered the mail accounts.  I then did some custom lookup coding and allowed them to enter a membership no and their postcode to reveal it.).

You say you have bulk registered them, with presumably a temporary password.  What I'd do is tell them their username in the newsletter and ask them to retrieve by email their own password using the login screen's "Forgot Password" link.  That way, the get a warm feeling it hasn't been read by you or your office staff.

Here's the template for your newsletter.  The values for Firstname, Lastname, Username all render-out when you send it to all in a role.

Make a temptest role and register yourself as a tester in it.  Uee that role to test all your newsletter emails before blasting them out to the whole list.

http://www.xyz.org/MyClub/MyOptIns/