See Code Syntax Below, Change E Mail Body to Subject ?

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I would like to instead of inserting Gulf Coast Electric into the body, put
it in the Subject instead !
Can this be done ?

DoCmd.SendObject acSendNoObject, "FormTyp", acFormatHTML, [Text173], , , ,
"From Gulf Coast Electric", True, ""
 
Dave,

Yes, you can move the Message Text argument to the Subject Argument. The
order of arguments for SendObject() is:

SendObject(ObjectType, _
ObjectName, _
OutputFormat, _
To, _
Cc, _
Bcc, _
Subject, _
MessageText, _
EditMessage, _
TemplateFile)

So, just put the text "From Gulf Coast Electric" in the appropriate
position.
 
So exactly how do I or where do I change the code so that this works,
confused ?
See Code Below

Thanks,

Dave

Cheryl Fischer said:
Dave,

Yes, you can move the Message Text argument to the Subject Argument. The
order of arguments for SendObject() is:

SendObject(ObjectType, _
ObjectName, _
OutputFormat, _
To, _
Cc, _
Bcc, _
Subject, _
MessageText, _
EditMessage, _
TemplateFile)

So, just put the text "From Gulf Coast Electric" in the appropriate
position.



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Dave Elliott said:
I would like to instead of inserting Gulf Coast Electric into the body, put
it in the Subject instead !
Can this be done ?

DoCmd.SendObject acSendNoObject, "FormTyp", acFormatHTML, [Text173], , , ,
"From Gulf Coast Electric", True, ""
Click to expand...
Click to expand...
 
Dave Elliott said:
So exactly how do I or where do I change the code so that this works,
confused ?
See Code Below
Click to expand...

Dave, Go to Tools - Options - Module and see if the "Auto-" options are enabled
under coding options. With these enabled, as you type the command in a VBA
window you will get text displayed on screen telling exactly what each argument
position you are in based on the commas separating the arguments. You should be
able to "arrow" through the statement until it tells you that you are positioned
at the Argument you want. Your original syntax simply has one too many commas
in front of your text and needs it moved after it.
 
Dave,

Look at your current function call. Those commas with nothing behind them
are argument markers, which have to be there so that the function will know
what your variables mean. When you see that there are no values between
these commas, that denotes that an optional argument could have been
inserted there but was not.

So, cut your text "From Gulf Coast Electric" from its current position in
your function - *leaving the comma* - and paste it back into your function
in the position reserved for Subject. Here is a representation using your
argument values:

DoCmd.SendObject acSendNoObject, "FormTyp", acFormatHTML, _
[Text173], <leave blank if no CC>, <leave blank if no BCC>, _
<leave blank if no Subj> , "From Gulf Coast Electric", True, ""




--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Dave Elliott said:
So exactly how do I or where do I change the code so that this works,
confused ?
See Code Below

Thanks,

Dave

Cheryl Fischer said:
Dave,

Yes, you can move the Message Text argument to the Subject Argument. The
order of arguments for SendObject() is:

SendObject(ObjectType, _
ObjectName, _
OutputFormat, _
To, _
Cc, _
Bcc, _
Subject, _
MessageText, _
EditMessage, _
TemplateFile)

So, just put the text "From Gulf Coast Electric" in the appropriate
position.



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Dave Elliott said:
I would like to instead of inserting Gulf Coast Electric into the
Click to expand...
body,
put
it in the Subject instead !
Can this be done ?

DoCmd.SendObject acSendNoObject, "FormTyp", acFormatHTML, [Text173], ,
Click to expand...
Click to expand...
,
,
Click to expand...
Click to expand...
 
Back
Top