•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 427,495 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,456 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 1908 | Replies: 0
![]() |
•
•
Join Date: Feb 2005
Posts: 20
Reputation:
Rep Power: 4
Solved Threads: 0
Hey All,
I have created the following code in my data base. It works correctly except that the email it creates is in the rich text format. I want it to be in plain text format. The default settings in outlook are set to plain text, but my code seems to over ride the default settings.
Any help would be greatly appreciated!
Stick
' Create the Outlook session.
Set objOutlook = CreateObject("Outlook.Application")
' Create the e-mail message.
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
With objOutlookMsg
' Add the To recipients to the e-mail message.
Set objOutlookRecip = .Recipients.Add(Forms!quote_form!CUSTEM)
objOutlookRecip.Type = olTo
' Add the Cc recipients to the e-mail message.
If (IsNull(Forms!quote_form!SALESEM)) Then
Else
Set objOutlookRecip = .Recipients.Add(Forms!quote_form!SALESEM)
objOutlookRecip.Type = olCC
End If
' Set the Subject, the Body, and the Importance of the e-mail message.
.Subject = "Mold Base Quotation"
.Body = "Thank you for the opportunity to quote your mold base needs. Please call with any quetions you may have."
.Importance = olImportanceHigh 'High importance
'Add the attachment to the e-mail message.
If Not IsMissing("c:\quotation.pdf") Then
Set objOutlookAttach = .Attachments.Add("c:\quotation.pdf")
End If
' Resolve the name of each Recipient.
For Each objOutlookRecip In .Recipients
objOutlookRecip.Resolve
If Not objOutlookRecip.Resolve Then
objOutlookMsg.Display
End If
Next
.Display
End With
Set objOutlookMsg = Nothing
Set objOutlook = Nothing
I have created the following code in my data base. It works correctly except that the email it creates is in the rich text format. I want it to be in plain text format. The default settings in outlook are set to plain text, but my code seems to over ride the default settings.
Any help would be greatly appreciated!
Stick
' Create the Outlook session.
Set objOutlook = CreateObject("Outlook.Application")
' Create the e-mail message.
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
With objOutlookMsg
' Add the To recipients to the e-mail message.
Set objOutlookRecip = .Recipients.Add(Forms!quote_form!CUSTEM)
objOutlookRecip.Type = olTo
' Add the Cc recipients to the e-mail message.
If (IsNull(Forms!quote_form!SALESEM)) Then
Else
Set objOutlookRecip = .Recipients.Add(Forms!quote_form!SALESEM)
objOutlookRecip.Type = olCC
End If
' Set the Subject, the Body, and the Importance of the e-mail message.
.Subject = "Mold Base Quotation"
.Body = "Thank you for the opportunity to quote your mold base needs. Please call with any quetions you may have."
.Importance = olImportanceHigh 'High importance
'Add the attachment to the e-mail message.
If Not IsMissing("c:\quotation.pdf") Then
Set objOutlookAttach = .Attachments.Add("c:\quotation.pdf")
End If
' Resolve the name of each Recipient.
For Each objOutlookRecip In .Recipients
objOutlookRecip.Resolve
If Not objOutlookRecip.Resolve Then
objOutlookMsg.Display
End If
Next
.Display
End With
Set objOutlookMsg = Nothing
Set objOutlook = Nothing
![]() |
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
access advertisment apple bluray browser cell code combo computing core data dropdownlist dual dvd email encryption eu firefox format gmail google hd layer microsoft mobile module mozilla net news onecare opinion penelope phishing phones pro processor professional research reuse security sony spam spammers spamming technology thunderbird virus war web webmail
- Email Validation Rule with MS ACCESS (MS Access and FileMaker Pro)
- Is it possible to display report in Visual Basic which is created in Microsoft Access (Visual Basic 4 / 5 / 6)
- HELP: created dreamweaver form, but how do i get results from form? (PHP)
- another newbie with alot of redhat and apache server Q'S (Linux Servers and Apache)
- Director exporting wrong (Graphics and Multimedia)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: sendobject command in MS Access 2000
- Next Thread: Error in Shared Microsoft Access


Linear Mode