Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / April 2006

Tip: Looking for answers? Try searching our database.

Save Form In SharePoint / Include Link to it in an Email

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
marknavidstrand@yahoo.com - 28 Mar 2006 15:15 GMT
I am saving my infopath form to a SharePoint site and then sending an
email to a user telling him that the form has been saved - but - i need
to include a link to the form on the SharePoint site in the body of the
email.  Can I do that?

Here's the vbscript code that sends the email.

Dim objOutlook
   Dim objOutlookMsg
   Dim objOutlookRecip
   Dim objOutlookAttach
   Dim frmSavePath

   Set objOutlook = CreateObject("Outlook.Application")
   Set objOutlookMsg = objOutlook.CreateItem(0)

   With objOutlookMsg
         Set objOutlookRecip = .Recipients.Add("john.doe@test.com")
         objOutlookRecip.Type = 1
        .Subject = "The Project Leader has sign the form"
        .body = "The project leader has signed the form.  Your turn."
        .Importance = 2  'High importance

         For Each objOutlookRecip In .Recipients
    objOutlookRecip.Resolve
    Next

        .display
   End With

   Set objOutlook = Nothing
   Set objOutlookMsg = Nothing
   Set objOutlookRecip = Nothing
   Set objOutlookAttach = Nothing
S.Y.M. Wong-A-Ton - 01 Apr 2006 16:51 GMT
If you are submitting through code, you can retrieve the data connection you
have set up to submit to SharePoint (this will be a DAVAdapter object - see
http://msdn.microsoft.com/library/en-us/ipsdk/html/xdobjDAVAdapterObject_HV01106
498.asp?frame=true
)
and then use its FileName and FolderURL properties to generate the full URL
to the submitted form. Include this URL in the code to send the email.
---
S.Y.M. Wong-A-Ton


> I am saving my infopath form to a SharePoint site and then sending an
> email to a user telling him that the form has been saved - but - i need
[quoted text clipped - 30 lines]
>     Set objOutlookRecip = Nothing
>     Set objOutlookAttach = Nothing
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.