S
Stephen Green
Can I create a database results page that send its results (e-mail
addresses) to Outlook for sending mail?
Stephen
addresses) to Outlook for sending mail?
Stephen
T
Thomas A. Rowe
No. You would use a custom written script that would retrieve the email addresses from a table in
the database then send the out the email using a ASP email component that is installed on the
server.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
the database then send the out the email using a ASP email component that is installed on the
server.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
J
Jim Buyens
No.
However, you *can* write an ASP page that sends the mail,
and that sets the addressees to whatever you want. For an
admittedly non-database example, refer to:
Mailing Form Data
http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=46
Another option, which I've occsionally done, is to have
the database query display nothing but the e-mail
addresses, as text, and with semicolons after each
address. Then, the Web visitor can copy the addresses to
the clipboard and paste them into the Oulook To: box.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
However, you *can* write an ASP page that sends the mail,
and that sets the addressees to whatever you want. For an
admittedly non-database example, refer to:
Mailing Form Data
http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=46
Another option, which I've occsionally done, is to have
the database query display nothing but the e-mail
addresses, as text, and with semicolons after each
address. Then, the Web visitor can copy the addresses to
the clipboard and paste them into the Oulook To: box.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
S
Stephen Green
Jim!
While I figure out how to write the ASP code to accomplish what I want, I
tried to get the e-mails into a database results page with semicolons as you
suggested. But, though I can get all the e-mails on the page, they are on
separate lines. I can't figure out how to change the formatting.
Stephen
While I figure out how to write the ASP code to accomplish what I want, I
tried to get the e-mails into a database results page with semicolons as you
suggested. But, though I can get all the e-mails on the page, they are on
separate lines. I can't figure out how to change the formatting.
Stephen
K
Kathleen Anderson [MVP - FrontPage]
Switch to HTML/Code View and remove the <p></p> tags.
--
~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
--
~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
S
Stephen Green
Brilliant!
Thanks.
Stephen
Thanks.
Stephen
Kathleen Anderson said:
K
Kathleen Anderson [MVP - FP]
Stephen Green said:
You're welcome
J
Jim Buyens
I had a feeling this might happen.
In the quick test I ran, I specified a custom query on page 2 of the
DRW. This query was similar to:
SELECT email & ";" AS emailscolon FROM mytable
where email is the name of the field containing the e-mail addresses,
and mytable is the name of the table that contains the desired
records. Of course, if you want to do record selection, you would also
have to code a WHERE clause.
Next, in page 3 of the DRW, I clicked Edit List and removed all the
fields except emailscolon.
Then, on page 4, I:
o Specified List - One Field Per Item.
o Cleared Add Labels For All Field Values.
o Cleared Place Horizontal Separator Between Records.
o Specified List Options: Line Breaks.
This produced something I could copy and paste into the To or Cc box
in Outlook.
The To or Cc box looked a little goofy until I tabbed out of it, but
it worked.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
In the quick test I ran, I specified a custom query on page 2 of the
DRW. This query was similar to:
SELECT email & ";" AS emailscolon FROM mytable
where email is the name of the field containing the e-mail addresses,
and mytable is the name of the table that contains the desired
records. Of course, if you want to do record selection, you would also
have to code a WHERE clause.
Next, in page 3 of the DRW, I clicked Edit List and removed all the
fields except emailscolon.
Then, on page 4, I:
o Specified List - One Field Per Item.
o Cleared Add Labels For All Field Values.
o Cleared Place Horizontal Separator Between Records.
o Specified List Options: Line Breaks.
This produced something I could copy and paste into the To or Cc box
in Outlook.
The To or Cc box looked a little goofy until I tabbed out of it, but
it worked.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
S
Stephen Green
Jim!
Thanks for the reply and the really interesting solution. Read Kathleen's
message above. Removing one tag did the trick! (For some reason FP inserts
<p> tags without corresponding </p> tags).
I'll try your solution, too. It's always good to learn new tricks.
Thanks again.
Stephen
Thanks for the reply and the really interesting solution. Read Kathleen's
message above. Removing one tag did the trick! (For some reason FP inserts
<p> tags without corresponding </p> tags).
I'll try your solution, too. It's always good to learn new tricks.
Thanks again.
Stephen