Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sending E-mail 1

Status
Not open for further replies.

mot98

MIS
Jan 25, 2002
647
CA
Hi All,

I have an Access form that my users fill out, and when they click on submit, it sends an e-mail to a certain group.

The end users have requested that they wan't to add e-mail addresses when they want to.

Is there a way I can just have the e-mail show before it sends, so that they could add an e-mail address if they want to.

So far my code to send the e-mail looks like this:
Code:
'Create a new mailitem
Set oItem = oOutlookApp.CreateItem(0)

With oItem
   'Set the recipient for the new email
   .To = "help@****.com"
   'Set the subject
   .Subject = "NEW CMS ISSUE!"
   'Set the message body
   .Body = stText
   .Send
End With

thanks for any idea's....

mot98
[cheers]
"Is it friday yet?"
 
Replace this:
.Send
with this:
.Display

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
lol..thanks..I was trying

.Show

Must be a monday...



mot98
[cheers]
"Is it friday yet?"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top