The CV211 Laptop USB Console Adapter provides a direct Laptop-to-Computer connection for fast and easy remote desktop access with no software to install.
Course Of The Month
3 days, left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Convert Text to HTML Table and e-mail
Posted on 2012-12-27
I have text file with following columns. I want the to converted to HTML table and the HTML file to be e-mailed.
NASvolumeName | DFSName | Total Size | Free Size
\\NAS01\Vol1 | \\Dom1\fileshr1 | 1,800 | 600
"|" should be used as a separator.
NASvolumeName | DFSName | Total Size | Free Size
\\NAS01\Vol1 | \\Dom1\fileshr1 | 1,800 | 600
"|" should be used as a separator.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
http://www.petri.co.il/forums/showthread.php?t=59619
Based on the topics selected, I'm assuming you're generating the output from VBS scripts.
If yes, then put set the output to HTML or create the email directly in an HTML format and send it from the VBS script.
http://www.petri.co.il/forums/showthread.php?t=59619
Alternatively, if you're getting the data in a .txt or .csv format then the easiest option is to create a macro in Excel.
I'm being a lazy admin here, but let me know if you need more help with the specific option you require...
Based on the topics selected, I'm assuming you're generating the output from VBS scripts.
If yes, then put set the output to HTML or create the email directly in an HTML format and send it from the VBS script.
http://www.petri.co.il/forums/showthread.php?t=59619
Alternatively, if you're getting the data in a .txt or .csv format then the easiest option is to create a macro in Excel.
I'm being a lazy admin here, but let me know if you need more help with the specific option you require...
With this script i tried to put for one volume but I am not sure how can do it for mutiple voulmes.....Here is teh script I am using....
Const wbemFlagReturnImmediately = &h10
Const wbemFlagForwardOnly = &h20
Set objFS = CreateObject("Scripting.FileSystemObject")
Set objNewFile = objFS.CreateTextFile("NASVolumeUsage.htm")
On Error Resume Next
a = "<style>"
a = a& "BODY{background-color:Lavender ;}"
a = a& "TABLE{font-size: 10pt; font-family: arial;}"
a = a& "TH{background-color: buttonface; font-decoration: bold;}"
a = a& "</style>"
objNewFile.WriteLine "<html>"
objNewFile.WriteLine "<head>"
objNewFile.WriteLine "<title>NAS Volume Usage Information</title>"
objNewFile.WriteLine a & "</head><body>"
objNewFile.WriteLine "<h2>NAS Volume Usage Information -- Date: " _
& Now() & "</h2>"
objNewFile.WriteLine "<table BORDER=""1"">"
objNewFile.WriteLine "<tr><th>NAS Volume Name</th><th>DFS Share Name</th><th>Total</th><th>Free</th></tr>"
Dim result , machine , drvletter , netpath , dompath
Dim objNetwork , objDrive , objFSO
Const Decimals = 2
netpath = "\\nas1\vol1"
dompath = "\\domain1\dfs1"
Set objNetwork = CreateObject("WScript.Network")
Set objFSO = CreateObject("Scripting.FileSystemObject")
objNetwork.MapNetworkDrive "y:", netpath
Set objDrive = objFSO.Drives("y:\")
Total = FormatNumber(objDrive.TotalSize /1073741824, Decimals)
Free = FormatNumber(objDrive.FreeSpace /1073741824, Decimals)
objNewFile.WriteLine "<tr><td> " & netpath & " </td><td> " & dompath & "</td><td> " & Total & "</td><td> " & Free & "</td></tr>"
objNetwork.RemoveNetworkDrive "y:"
objNewFile.WriteLine "</table>"
objNewFile.WriteLine "<br />"
objNewFile.WriteLine "</body>"
objNewFile.WriteLine "</html>"
objNewFile.Close
wscript.quit
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Many of us in IT utilize a combination of roaming profiles and folder redirection to ensure user information carries over from one workstation to another; in my environment, it was to enable virtualization without needing a separate desktop for each…
Trying to figure out group policy inheritance and which settings apply where can be a chore. Here's a very simple summary I've written which might help. Keep in mind, this is just a high-level conceptual overview where I try to avoid getting bogge…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special.
It's completely agentless, but does let you create an agent, if you desire.
It offers powerful scalability …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Suggested Courses
Course of the Month3 days, left to enroll
Earn Certification
MTA Server Fundamentals Exam 98-365
$59.00$53.10
695 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.