Calling a Word Macro from Access

[Curt]

Does anyone know how to call a Word document Macro from
Access. I am trying to auto send an attachment from
Access.

The Macro is

Public Sub Send()
Options.SendMailAttach = True
ActiveDocument.SendMail
End Sub


Thanks for advice

 

[Kailash Kalyani]

Alternatively you could automate Outlook if you use it as the mail client

to add an attachment
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaol10/html/olobjMailItem.asp

to send mail - this one has more detail
http://support.microsoft.com/default.aspx?scid=kb;en-us;220595