Auto send through macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Curt - 29 Apr 2004 05:16 GMT

I am new to using VB with Word. I have been using Access
for awhile. What I am trying to do is be able to call a
macro from Access to a word document.

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

I know some will say go to Access group, but I was hoping
someone here will explain on how to call a macro if from
word. What I am doing is I have a template that is Mail
merged through Access once the document is updatd I want
to auto populate Outlook 2002/2002 so it can be sent. How
can I do this? Thanks for any response

Reply to this Message

Doug Robbins - Word MVP - 29 Apr 2004 14:21 GMT

See the article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I am new to using VB with Word. I have been using Access
> for awhile. What I am trying to do is be able to call a
[quoted text clipped - 11 lines]
> to auto populate Outlook 2002/2002 so it can be sent. How
> can I do this? Thanks for any response

Reply to this Message