Creating and Formating Outlook Task

[steve-bart]

I am not a very experienced Access programmer, so please forgive if this a very basic question.

I'm using the following code to generate and assign an Outlook Task. My question is; is it possible to include a table and or picture in the Task. I know that you can't use HTML in creating tasks.

Many thanks in anticipation.

Dim strAnsDate As String
Dim strAnsTime As String
Dim myOlApp As Object
Dim myItem As Outlook.TaskItem
Dim myDelegate As Outlook.Recipients
Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(olTaskItem)
myItem.Recipients.Add ("Email.add")
myItem.Subject = "Subject"
myItem.Body = "Subject body"
myItem.Importance = olImportanceHigh
myItem.DueDate = #9/15/2011#
myItem.Assign
myItem.StartDate = Now()
myItem.Categories = "Category"
myItem.Save
myItem.Send

[rpeare]

I've never tried to send an attachment with a task/meeting request but have you tried creating just a sample file (just put it in your c:\ drive and call it Test.txt)

Then in your email building routine put in:

myItem.attachment = "c:\test.txt"

and see if it will correctly attach the file? if so then there's no reason you can't attach the contents of a table, though why you would want to do that eludes me, you may need to export the data to a file first then attach the file to the email but I haven't ever tried to attach a table to an email either

[steve-bart]

Thasnks for your reply RPEARE.
I already use Access to send emails and harvest documents from folders and this works fine.

What I need to do is to include on a Task data from the database in the form of a table. This is so that the recipient has all the necessary information for the Task which is being requeste.