Automatically sending a daily report in word as an attachment

Automatically sending a daily report in word as an attachment

Post by VG9t » Sat, 09 Jan 2010 20:19:03



I hope you can help with this. I have a daily report that needs to be mailed
to a co-worker. It is a simple list of clients served in a word 2003
document. I would like to automate the process. I right clicked on a toolbar
and went to customize, I found the command send mail recipient as attachment
and dragged the button to the standard toolbar. I assigned an email hyperlink
to it. The button works perfectly as far as sending an email automatically
but it doesn't send the contents of the document on the screen. I want the
current document to be attached to the email as it is sent. What am I doing
wrong. I saved the report and reopened it , typed in new information and
still nothing. Any sugggestions

Thanks
Tom
 
 
 

Automatically sending a daily report in word as an attachment

Post by Doug Robbi » Sun, 10 Jan 2010 19:57:35

See the article "How to send an email from Word using VBAat:
http://www.yqcomputer.com/


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com


>> I hope you can help with this. I have a daily report that needs to be >> mailed >> to a co-worker. It is a simple list of clients served in a word 2003 >> document. I would like to automate the process. I right clicked on a >> toolbar >> and went to customize, I found the command send mail recipient as >> attachment >> and dragged the button to the standard toolbar. I assigned an email >> hyperlink >> to it. The button works perfectly as far as sending an email automatically >> but it doesn't send the contents of the document on the screen. I want the >> current document to be attached to the email as it is sent. What am I >> doing >> wrong. I saved the report and reopened it , typed in new information and >> still nothing. Any sugggestions >> >> Thanks >> Tom