How to send the same form to different email addresses using macros?

kjdemeyer · #1 04-27-2009, 03:06 PM

I have a Word form that gets send to a specific email address when it is saved, but now I want to send the same form to different email addresses based on a selection in the form. Form example if they select "yes" the form would go to one email address, but if they choose "no" it would get sent to a different email address. How do I change the macro language to accomplish this. Here is a sample of the current language:

Code:

'create email message using the account number as the subject and delivers the
'document to all recipients
    ActiveDocument.HasRoutingSlip = True
    With ActiveDocument.RoutingSlip
        '.Subject = ActiveDocument.FormFields("txtAcctNum").Result & " - " & ActiveDocument.FormFields("txtInsdNm").Result
        .Subject = "Cancellation Request for " & ActiveDocument.FormFields("txtInsdNm").Result
        .Message = "Please see attached Cancellation Request."
        .AddRecipient Recipient:="LewistonMMProduction@LibertyMutual.com"
        .Delivery = wdAllAtOnce
        .ReturnWhenDone = False
        .TrackStatus = False
    End With

Welcome to the Excel Forum

Forum Statistics