clvestin
01-21-2007, 09:05 AM
In my continuing quest , I have found that code such as
With objmailitem
.To = "joe blow (blow@nngco.com;tom)"
.Subject = "subject"
.Attachments.Add "c:\filename.xls"
.Send
End With
won't really send my mail for me. It does however place the mail in Outlook's Outbox. (half the job, to my thinking)
If further
Application.ActivateMicrosoftApp xlMicrosoftMail
objOLapp.Session.SyncObjects.Item(1).Start
Outlook opens, and the Send/Receive action takes place.
Outlook remains open in my routine, but the mail has been sent.
I'm not all that clear what I'm doing with the whole SyncObjects scenario, but perhaps someone can clear this issue up for me. Any advice would be appreciated.
With objmailitem
.To = "joe blow (blow@nngco.com;tom)"
.Subject = "subject"
.Attachments.Add "c:\filename.xls"
.Send
End With
won't really send my mail for me. It does however place the mail in Outlook's Outbox. (half the job, to my thinking)
If further
Application.ActivateMicrosoftApp xlMicrosoftMail
objOLapp.Session.SyncObjects.Item(1).Start
Outlook opens, and the Send/Receive action takes place.
Outlook remains open in my routine, but the mail has been sent.
I'm not all that clear what I'm doing with the whole SyncObjects scenario, but perhaps someone can clear this issue up for me. Any advice would be appreciated.