Send form using Outlook, "For Astrid" 
Author Message
 Send form using Outlook, "For Astrid"

Astrid,
About using the Send to Routing Recepient to send a word
doc through outlook.

I figured out a way to get around the problem.
When i use the code to send the form the first time, its
ok.
but if i use it again, it will error out.
Why, The only thing i can think of is because when
something is sent through the Routing method, it shows
send to next routing recepient, and does not show send to
mail recepient.  Something changes when its sent through
that method.
So if i make the form, and never have it saved before its
sent for the first time, i have no problems.

Here is the code if your interested.

ActiveDocument.HasRoutingSlip = True
With ActiveDocument.RoutingSlip
  .Subject = "Supply Request"


  .Delivery = wdAllAtOnce
End With
ActiveDocument.Route

Msg = "Message Has Been Sent!"
   Style = vbOK
   Title = "Sent"
   response = MsgBox(Msg)

Thanks,

Nick



Sat, 31 Jul 2004 00:42:12 GMT  
 Send form using Outlook, "For Astrid"
Hi Nick,

Quote:
> When i use the code to send the form the first time, its
> ok.
> but if i use it again, it will error out.

Ok. So what exactly do you mean? Is your code in a template(.dot) or in a document (.doc)
If the latter, is what you're saying is, I made a document, send it once and it was ok, send the same doc for the second time and it's not ok?
It could be that since the routingslip is set the first time, it errors the second time because it's still filled in a sort of way.
What happens if you first set the HasRoutingSlip property to False and then to True again?

    ActiveDocument.HasRoutingSlip = False
    ActiveDocument.HasRoutingSlip = True

Hope this helps,
regards,
Astrid

So that all can benefit from the discussion, please post all follow-ups to the newsgroup.
Visit the MVP Word FAQ site at http://www.mvps.org/word/



Sat, 31 Jul 2004 05:25:19 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Automatically have Outlook start "send/receive"

2. Need to set "Send Message Using"

3. Using "Item.Send"

4. How to use "unload form", "form.hide", "form.visible =false "?

5. "Overflow error" when sending FORM

6. Using "Send To" with ShellExecute

7. How to use "unload form", "form.hide", "form.visible =false "?

8. How to use "unload form", "form.hide", "form.visible =false "?

9. Displaying "Outlook Address List" Dialog Form

10. Send without putting in "Sent"?

11. Using "age" function in Word form

12. Using ActiveX controls as "dynamic forms"?

 

 
Powered by phpBB® Forum Software