abbaddon223
Registered User.
- Local time
- Today, 12:33
- Joined
- Mar 13, 2010
- Messages
- 162
Okay,
This is something I appreciate I should know (blushes with shame).
I'm using the below to create an outlook event which is being populated (to, subject and body) from an access form.
Private Sub Command14_Click()
Dim Olk As Outlook.Application
Set Olk = CreateObject("Outlook.Application")
Dim OlkMsg As Outlook.Mailitem
Set OlkMsg = Olk.createitem(olmailitem)
With OlkMsg
Dim Olkrecipt As Outlook.Recipient
Set OlkRecip = .Recipients.Add(Me![EmailAddress])
OlkRecip.Type = OlTo
.Subject = Forms!Frm_Email_Subject_body!Subject
.Body = Forms!Frm_Email_Out!CustomerForename & "," & Forms!Frm_Email_Subject_body!Body
.Display
End With
Set Olk = Nothing
Set OlkMsg = Nothing
Set OlkRecip = Nothing
End Sub
When outlook opens, it's size and font are small and horrid. How do I change this to say, Arial 10, without using HTML as this then means that the body text get's moved to1 line rather then paragraphed (as written).
Thanks for any assistance!!!
This is something I appreciate I should know (blushes with shame).
I'm using the below to create an outlook event which is being populated (to, subject and body) from an access form.
Private Sub Command14_Click()
Dim Olk As Outlook.Application
Set Olk = CreateObject("Outlook.Application")
Dim OlkMsg As Outlook.Mailitem
Set OlkMsg = Olk.createitem(olmailitem)
With OlkMsg
Dim Olkrecipt As Outlook.Recipient
Set OlkRecip = .Recipients.Add(Me![EmailAddress])
OlkRecip.Type = OlTo
.Subject = Forms!Frm_Email_Subject_body!Subject
.Body = Forms!Frm_Email_Out!CustomerForename & "," & Forms!Frm_Email_Subject_body!Body
.Display
End With
Set Olk = Nothing
Set OlkMsg = Nothing
Set OlkRecip = Nothing
End Sub
When outlook opens, it's size and font are small and horrid. How do I change this to say, Arial 10, without using HTML as this then means that the body text get's moved to1 line rather then paragraphed (as written).
Thanks for any assistance!!!