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:
thanks for any idea's....
mot98
![[cheers] [cheers] [cheers]](/data/assets/smilies/cheers.gif)
"Is it friday yet?"
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] [cheers] [cheers]](/data/assets/smilies/cheers.gif)
"Is it friday yet?"