Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

ASP Email, a new twist

Posted on 2007-04-04
2
185 Views
Last Modified: 2010-04-16
I have an access database I'm accessing through ASP.  I have ASP pages that show a snapshot of information about a record or person.  I want to email them that information as a confirmation.  I DON'T want to autoemail it through the server using CDO.  I want to generate an email with all the data I've defined in the BODY of the email, and (if possible) a Subject line I choose, and view/edit the email before I send it.
I can't use the A HREF:MAILTO function because it cuts off the number of characters in the body, and I want a full page (with formatting).  I also can't use that function because it doesn't allow spaces in my Subject line.  
I use CDO to auto-send emails, but that's not what I want to do, I want to see the email in front of me for last minute verification and alteration before I send it.  
I know how to take an ASP page and tell it to become an Excel file, and I tried the same thing to make it become an Outlook file, but it didn't work.
What can I do to generate an email with all my data and formatting in the body, a subject line that contains spaces and hopefully even the Email address filled in?
0
Comment
Question by:Mannezman
2 Comments
 
LVL 8

Expert Comment

by:jawahar_prasad
ID: 18850302
OK..
Before sending the email, just fetch the data from the database and put the email in the text box, subject in the text box, body in the textarea and the submit button below..

You can modify the content and click send, so that the email will be sent to the recipient...
0
 
LVL 10

Accepted Solution

by:
Si_Hibbard earned 250 total points
ID: 18850317
Create a new asp page, and call this with the recordid etc passed in.

The page should query the DB for the info on the record and populate some text boxes - email address, subject, body for example on a form. Place a submit button on the page which send the form to a script which simply takes the textbox data and sends an email via CDO and displays a message to say the email has been sent.

Thats how i would tackle the problem.

0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this tutorial I will show you how to make a simple HTML bar chart with the usage of WhizBase, If you want more information about WhizBase please read my previous articles at http://www.experts-exchange.com/ARTH_5123186.html (http://www.experts-ex…
Batch, VBS, and scripts in general are incredibly useful for repetitive tasks.  Some tasks can take a while to complete and it can be annoying to check back only to discover that your script finished 5 minutes ago.  Some scripts may complete nearly …
Learn the basics of strings in Python: declaration, operations, indices, and slicing. Strings are declared with quotations; for example: s = "string": Strings are immutable.: Strings may be concatenated or multiplied using the addition and multiplic…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question