macro to add attachment

W

wytkat28

I'm sure this has been covered before, but I haven't found anythin
specifically addressing my problem in the search.

I am writing a macro for my boss that will open a Word file, show Emai
form, and automatically add 2 attachments. He will fill in the rest o
information before he sends. The only part of the macro I haven't bee
able to figure out is how to add the attachments. The attachments wil
always be the same 2 files in the same location. I know this i
relatively simple, but I'm still pretty new to VB and am stuck.

Thanks for the help.

As a second thought...How difficult would it be to have a message bo
come up after he hits "Send as a Copy" asking him if wants to sen
another message or not. If he selects yes send another, don't clos
the document and repeat the previous macro, if no close the documen
without saving
 
D

Doug Robbins - Word MVP

See the article “How to send an email from Word using VBA” at:

http://word.mvps.org/FAQs/InterDev/SendMail.htm


--
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
 
W

wytkat28

But this doesn't say anything about automatically attaching a file lik
a .pdf. And I still can't find how
 
W

wytkat28

But this doesn't say anything about automatically attaching a file lik
a .pdf. And I still can't find how
 
W

wytkat28

But this doesn't say anything about automatically attaching a file lik
a .pdf. And I still can't find how
 
D

Doug Robbins - Word MVP

Study the code in the macro in the article and please ask IRubin to fix up
his crappy WordForums.com website so that it doesn't cause duplicates and
triplicates of the messages posted to his site to appear on the servers that
actually host these newsgroups. For you own part, I would suggest that you
do not access the newsgroups via WordForums.com. If you can, use a
newsreader such as Outlook Express. If you cannot use that, then connect to
the newsgroups via http://communities.microsoft.com/newsgroups/default.asp
Your posts will appear more promptly and answers will also be available as
soon as they are posted, rather than when IRubin gets around to it.

--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top