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)
|/---------------------------------------------------
*----------------------------------------------------
"Stephen Green" <(E-Mail Removed)> wrote in message news:<#r$(E-Mail Removed)>...
> 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
>
> "Jim Buyens" <(E-Mail Removed)> wrote in message
> news:86c001c4783d$84bfff90$(E-Mail Removed)...
> > 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/tip...ow.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)
> > |/---------------------------------------------------
> > *----------------------------------------------------
> >
> >
> >
> >
> >
> > >-----Original Message-----
> > >Can I create a database results page that send its
> results (e-mail
> > >addresses) to Outlook for sending mail?
> > >
> > >Stephen
> > >
> > >
> > >.
> > >
Similar Threads
