Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   design new mail from code in access (http://www.outlookbanter.com/outlook-vba/47689-design-new-mail-code-access.html)

rach May 7th 07 02:01 PM

design new mail from code in access
 
hi,
i have this code:
Dim objOutlook As Outlook.Application
Dim objMail As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
Dim db As Database
Dim msg As String

Set db = CurrentDb()
Set objOutlook = New Outlook.Application
Set objMail = objOutlook.CreateItem(olMailItem)
msg = "hello," & vbcrlf & "good morning""
With objMail
Set objOutlookRecip = .Recipients.Add(Email)
.Display
.Subject = "hello"
.Body = msg
end with


i want to align it (the body) to right to set the font, add a picture etc' ,
how can i design this mail?


Dmitry Streblechenko May 7th 07 07:03 PM

design new mail from code in access
 
Instead of using the Body property, set the HTMLBody property to the
appropriately formatted HTML string.

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"rach" wrote in message
...
hi,
i have this code:
Dim objOutlook As Outlook.Application
Dim objMail As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
Dim db As Database
Dim msg As String

Set db = CurrentDb()
Set objOutlook = New Outlook.Application
Set objMail = objOutlook.CreateItem(olMailItem)
msg = "hello," & vbcrlf & "good morning""
With objMail
Set objOutlookRecip = .Recipients.Add(Email)
.Display
.Subject = "hello"
.Body = msg
end with


i want to align it (the body) to right to set the font, add a picture
etc' ,
how can i design this mail?





All times are GMT +1. The time now is 09:25 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com