Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Jane Jane is offline
external usenet poster
 
Posts: 87
Default A Macro to E-mail Attachment from Word

Hi,

I'm issuing a survey to my customers and would like to make it easy for them
to return it to me. I've created the form and want to create a macro and
assign it to the toolbar as a button they can press. Initially I recorded
the Macro, but entering my e-mail address in the send to field didn't work.
I found the following code somewhere, but it is crashing Word every time I
test it. I have zilch knowledge of VBA, and really just copied this code in.
Can any one pls suggest how to change it? Is there something wrong with it,
or with my Word in general? Where it says "filename" and "e-mail address" I
do have the correct info there.

Thanks,

Jane
-----------------------------

Sub ReturnSurvey()
'
' ReturnSurvey Macro
' Macro recorded 7/09/2006 by Jane
'
ActiveDocument.HasRoutingSlip = True
With ActiveDocument.RoutingSlip
.Subject = "filename"
.AddRecipient "e-mail address"
.Delivery = wdAllAtOnce
End With
ActiveDocument.Route

End Sub


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Can't get Word 2003 to keep data file with mail merge main documen Yourcareercoach Mailmerge 9 August 10th 06 12:19 PM
I am having difficulty with deleting headers and footers LHD New Users 5 July 24th 06 01:44 AM
glossary macro in Word? Tipuana Microsoft Word Help 7 June 10th 06 07:06 PM
WP merge file to Word sstires Tables 4 February 14th 06 06:26 PM


All times are GMT +1. The time now is 01:32 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"