Access2000 to Outlook2000 Coding question

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hi Everybody

I am using the following code to produce a mail item with an
Access2000 report attached.

Is there any way to specify

1. Wrap at 132
2. Make a larger Email than the usual minimum size thing that pops up.
3. Plain Text only

Dim stDocName As String
stDocName = "rptInvoice"
DoCmd.SendObject acReport, stDocName, acFormatRTF, _
Forms![frmCustomerWriteInvoice]![txtCustomerPrimaryEmail], _
Forms![frmCustomerWriteInvoice]![txtCC], _
Forms![frmCustomerWriteInvoice]![txtBCC], _
Forms![frmCustomerWriteInvoice]![txtSubject], _
Forms![frmCustomerWriteInvoice]![MemoInvoiceNotes]


Thanks in advance

Smiley Bob
 
The size of the email window when an item is opened is up to the user's
settings.

You are specifying RTF format. Use acFormatTXT instead.

If you want to wrap text you would have to do so yourself by adding vbCRLF's
where you want the text wrapped. To do so you need to get the text into a
string and parse the string adding those newline characters where you want
them..
 
On Mon, 24 May 2004 08:45:27 -0400, "Ken Slovak - [MVP - Outlook]"
to Ken Slovak

Thanks for your answers.
The size of the email window when an item is opened is up to the user's
settings.
Click to expand...

So it would appear that there is no way to control the size of the
email window from within the Ms Access program.
However, I find that if I send an email from within Ms Outlook and
save at a large size before sending, any new emails from within Ms
Outlook now are formed in the new large size. But! this does not apply
to emails sent from within the Ms Access program. They still are
produced at the minimum size.
You are specifying RTF format. Use acFormatTXT instead.
Click to expand...

acFormatTXT. Another thing you have taught me!! However it is almost
impossible to align a Ms Access Form/Subform Invoice using a text
file.
Snapshot is the best format but not many non Access users have a
snapshot reader installed. RTF is a bit ancient and doesn't display
any graphics, but neary everyone has Ms Word and that makes it the
best bet for emailing an invoice.
If you want to wrap text you would have to do so yourself by adding vbCRLF's
where you want the text wrapped. To do so you need to get the text into a
string and parse the string adding those newline characters where you want
them..
Click to expand...

Thanks for the help

Smiley Bob
 
Email window size is also a problem when you use something like Word's
SendTo. If you were using Outlook object model code you could get the open
email window as an Inspector (ActiveInspector in this case) and use the
Inspector's Height and Width properties to control the window size. Not from
SendObject though.




Bob said:
On Mon, 24 May 2004 08:45:27 -0400, "Ken Slovak - [MVP - Outlook]"
to Ken Slovak

Thanks for your answers.
The size of the email window when an item is opened is up to the user's
settings.
Click to expand...

So it would appear that there is no way to control the size of the
email window from within the Ms Access program.
However, I find that if I send an email from within Ms Outlook and
save at a large size before sending, any new emails from within Ms
Outlook now are formed in the new large size. But! this does not apply
to emails sent from within the Ms Access program. They still are
produced at the minimum size.
You are specifying RTF format. Use acFormatTXT instead.
Click to expand...

acFormatTXT. Another thing you have taught me!! However it is almost
impossible to align a Ms Access Form/Subform Invoice using a text
file.
Snapshot is the best format but not many non Access users have a
snapshot reader installed. RTF is a bit ancient and doesn't display
any graphics, but neary everyone has Ms Word and that makes it the
best bet for emailing an invoice.
If you want to wrap text you would have to do so yourself by adding vbCRLF's
where you want the text wrapped. To do so you need to get the text into a
string and parse the string adding those newline characters where you want
them..
Click to expand...

Thanks for the help

Smiley Bob
Click to expand...
 
Back
Top