Email (docmd?)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rpettis31 - 30 Apr 2008 04:04 GMT

Hello, I had a macro that sent an email however the message box in out look
is to small and cumbersome to have a long message.

What I am trying to do is send a message based on values on a form.

For example ( Issue [0001] has been created for item 12345)

I am not sure how I should so this other than an on click event from the
command button I have already set up.

No attachments or reports just some values from the form.

Reply to this Message

Stockwell43 - 30 Apr 2008 16:37 GMT

Hi Rpettis31,

Try this behind your button and modify the First Name, Last Name etc.. to
fit your needs.

On Error GoTo EH
Dim SendTo As String, SendCC As String, MySubject As String, MyMessage
As String
SendTo = "dal.wl@bank.com, al.john@bank.com"
SendCC = "tor.wl@bank.com, les.john@bank.com"
MySubject = "Additional Information Needed"
MyMessage = Me.LoanNumber & vbCr & Me.CustomerFirst & " " &
Me.CustomerLast & vbCr & Me.ErrorCode & _
vbCr & Me.Comments
DoCmd.SendObject acSendNoObject, , , SendTo, SendCC, , MySubject,
MyMessage, True

EH:
If Err.Number = 2501 Then
MsgBox "This email message has not been sent. Message has been
cancelled."
End If

I've been using this piece of code for three years and never had a problem.
Hope this helps!

> Hello, I had a macro that sent an email however the message box in out look
> is to small and cumbersome to have a long message.
[quoted text clipped - 7 lines]
>
> No attachments or reports just some values from the form.

Reply to this Message

louise cassel - 06 May 2008 06:58 GMT

i'm having problems loading email to windows it says can't connect to
server. Help!

> Hello, I had a macro that sent an email however the message box in out
> look
[quoted text clipped - 8 lines]
>
> No attachments or reports just some values from the form.

Reply to this Message

John W. Vinson - 08 May 2008 19:45 GMT

>i'm having problems loading email to windows it says can't connect to
>server. Help!

"Windows" doesn't do EMail. There are many EMail programs which run as
programs in the Windows operating system - Outlook, Outlook Express, Windows
Mail (yes, that's confusing, but it is an application program not the actual
Windows operating system).

All of these programs have forums like this one to help you with problems.
However, this particular forum is NOT for any of those programs, but instead
for the database software Microsoft Access.

Please scroll down the list of subjects and post your question in a newsgroup
supporting your particular mail software. It would help greatly to post the
name and version of the software that you are using, and indicate which server
(Yahoo???) you want to use.

Signature

John W. Vinson [MVP]

Reply to this Message