Attach Files to Emails generated in Access VBA



In Access, using VBA, I am sending emails based on query results. These
email include relevant information to a scheduled event the recipient is
assigned to. This is working great. What I have been ask to do now is
to include an attached file, that when opened will be an Outlook
Calendar event and when saved the event will be added to the recipient's
calendar in Outlook. These files are .vcs files. I am able to create
the necessary file, but what I am not able to do is attach the file to
the email message generated from Access. I am using the
"DoCmd.SendObject" command in Access to generate and send the email
messages.
I would appreciate any help in learning how to attached files to emails
generated in Access. Please reply to the thread. Thanks in advance for
your help.

Brian

*** Sent via Developersdex http://www.developersdex.com ***
.



Relevant Pages

  • Re: Create event in Outlook based on email message ?!?
    ... Sue Mosher, Outlook MVP ... > When I create an outlook event and add some recipient to it, ... > is sent a specially formatted email message about that event that actually ... > adds the event into the recipient's calendar. ...
    (microsoft.public.office.developer.outlook.vba)
  • Re: password protect one email?
    ... Outlook 2003 (and ensure that the recipient has Outlook 2003 on their end as ... "Cathy Tumlinson" wrote in message ... > Is there any way to attach a password to an email message? ...
    (microsoft.public.outlook)
  • Re: Outlook does not recognize names
    ... Are you adding each recipient one at a time using Recipients.Add and resolving each recipient object as you add it? ... Ken Slovak [MVP - Outlook] ... I've created some code in word that will generate an email message in ...
    (microsoft.public.office.developer.outlook.vba)
  •  ...What is it and how do I get rid of it?
    ... I am using Windows XP Home Edition with MS Outlook for ... Recently, when i send an email message to someone, ... the recipient will write back to me and ask "what is ... it is not apparent in my original composition of the ...
    (microsoft.public.windowsxp.perform_maintain)
  • Office XP document numbers can be linked to individual machines
    ... Outlook sticks four items in the ... The _AdHocReviewCycleID entry had me stumped until Beth Melton pointed me ... When you attach a document to an email message in Outlook 2002, ...
    (Bugtraq)