Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-05-2014, 08:56 AM
afppaul afppaul is offline extract node values from an XML file and insert into body of an email Windows 7 64bit extract node values from an XML file and insert into body of an email Office 2010 32bit
Novice
extract node values from an XML file and insert into body of an email
 
Join Date: May 2014
Posts: 2
afppaul is on a distinguished road
Default extract node values from an XML file and insert into body of an email


So far I have put together some code that looks in a public folder, gets any files that have been received in the past X amount if time, moves .rar file to a folder on the desktop, extracts XML file into sub folder and deletes the .rar file. To take this a bit further i've been asked to extract certain node values from XML file and insert them into the body of a new email. I'm able to open a new email and insert the proper To: Cc: and Subject. I'm just not sure how to extract the xml values and insert them into body of email. The schema for the xml file i'm told will always stay the same. By using the following code i'm able to view the full node schema and values in the intermadiate window of the vb editor. I would like to insert four of these values into the body of an email.

Code:
Dim xmlDocument As MSXML2.DOMDocument60
Set xmlDocument = New DOMDocument60
xmlDocument.Load ("file path and name.xml")
Debug.Print xmlDocument.xml
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert a hyperlink in body of email ChuckDrago Outlook 0 06-28-2013 06:51 AM
add hyperlink in body of Outlook email ChuckDrago Word 0 06-27-2013 01:13 PM
extract node values from an XML file and insert into body of an email need to extract email addresses from excel files dunndealpr Excel 3 06-07-2013 08:29 AM
extract node values from an XML file and insert into body of an email Insert a header name in the text (body) bal-007 Word 3 11-25-2011 01:08 PM
extract node values from an XML file and insert into body of an email Extract email address from field zssteen Excel 1 06-19-2009 02:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft