How do I send e-mail to all users? All I see is the Subject, Message body and then a search form with all my fields. Nothing about mailing to all users.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

As far as I understand this mod from what I've read in the forum:

It allows you to do a search for the users
who will receive the email and to enter the message in the form.

I would think that during the search you would somehow choose all users.

Have you tried doing the search and choosing all users?


Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/

Yeah, me too.

Take a look
http://www.fishhoo.com/.../team/reports/db.cgi

The above URL has been zapped for security reasons.

BTW, like your site.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Have you tried to send a mass mail?


JPD
http://www.jpdeni.com/dbman/

Yes,

I tried it specifying no parameters and it asked for parameters. I then put * in the RecordID. That one sent mail to only me. Probably because the first record is mine.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

It should have sent mail to everyone.

I really don't want to test this on your site because I don't want to send email to a lot of people who wouldn't appreciate it. How many records are in your database? Do they all have valid email addresses?

JPD
http://www.jpdeni.com/dbman/

Oh heck, go ahead. There's about 40 or so and they have e-mails. Check your PM for the full URL.

I finally learned how to turn on the images for this board and can't believe the dirty word filter came out of those sweet lips.



Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

We got here at exactly the same time.

Well, I tried the mailer and I only got one sent as well. You should be getting an email soon.

Oh, you don't know the places I've been!!!!

I'll go take another look at the code for the mailer and see if I can figure out the problem.

JPD
http://www.jpdeni.com/dbman/

I got it. Thanks for your help and let me know if I need to hang any text files for you.

Dang, you're up early.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

No, I'm up late. I haven't been to bed yet.

The good thing about my test is that I didn't bother all of the other people on your database.

Ya wanna try some things for me? If you're willing....

In sub mass_mail, change



to

$in{'mh'} = $#lines + 1;

See if that works any better.

JPD
http://www.jpdeni.com/dbman/

When I use a * in ID, it said sent to 58 users and I got mine.

Think you got it. You might consider including how to send to all users in your instructions.

Thanks for your help.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

I'm glad I was able to help you get it.

The reason it didn't send to all users was that you have your $db_maximum_hits set to 1. If you had it set to 10, it would probably have sent to 10 users. My problem was that the counting of the lines was incorrect. The new code is simpler, but it will guarantee that you get all users returned from the search.



JPD
http://www.jpdeni.com/dbman/

One little bitty thing. The mail it is sending contains a line like
-------------------------

I'm looking for the source of that now.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

This is the line in the code that creates:

--------------------

print MAIL "-" x 75 . "\n\n";

If you decide to remove the line, you should perhaps keep at least:

print MAIL "\n\n";

as this creates a separator from the subject and body of the email text.



Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/

Is there a way to have the success screen return a list of email addresses in addition to the numbers of members the email was sent to?

----------------
donm

Yeah.

In sub mass_mail, after

++$mail_count;

add

push (@sent_to,$rec{$db_email_field});

and change

&html_mass_mail_success($mail_count,@sent_to);

In sub html_mass_mail_success, change

my ($message) = $_[0];

to

my ($message,@users) = @_;

After

print qq|<$font>Your email message was sent to $message users.</font>|;

add

JPD
http://www.jpdeni.com/dbman/

Carol - Thanks - works GREAT !!!

----------------
donm

You're welcome, Don. I guess I'll go add that to the mod. If someone doesn't want it, they can delete the code.


JPD
http://www.jpdeni.com/dbman/

When I send a message to myself using this mod, the dashes appear as the first line in the body of the message. The subject appears in the message header as it should. I use Outlook Express as my main mail client. Do other clients handle this differently? From what I see, there is no need for this line.

Other opinions?

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

There's no need at all for the line. It's just there because it was in something that I copied to send email. Delete it if you don't want it.


JPD
http://www.jpdeni.com/dbman/

One more question about this MOD - is there a way to "blind copy" the admin?

I tried -

print MAIL "Bc: $admin_email\n";

and it does not work.

-----------------
donm

I've never been able to get a blind copy to work. Sorry.

JPD
http://www.jpdeni.com/dbman/

Okay, thanks.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

donm:

Try using:

$BCC="xxx\@yyyc.com"; ## enter the email address here

and then add this to mail statements.

print MAIL "BCC: $BCC\n";

Let me know if this works, as it's referenced in the FAQ below and I haven't tested it yet myself.

Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/

Lois:

Works Great !!!!

Thanks!
----------------
donm