How to import data into an email form and sent to a specific user?

I would like to automate the following, any type of VBScript, PowerShell or Batch Script would be fine.
Take an existing text file and import it into a word type template and send that template as an attachment via email - or
Take an existing text file and import It into the body and would look as a form.

Is there any existing software which could do this?
The software or script should fit into a current script so that when the script runs, so does this import and formatting.
100questionsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

QlemoBatchelor, Developer and EE Topic AdvisorCommented:
What does "form" mean in this context?
0
100questionsAuthor Commented:
To look like a form, where there are headers tgat are bold, titles that are bold, and where fields would be filled by the data which is imported
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Only building a HTML table is simple. Anything else is very specific to data and desired look. If you can create HTML code, sending it as email with PS is easy.
0
How do you know if your security is working?

Protecting your business doesn’t have to mean sifting through endless alerts and notifications. With WatchGuard Total Security Suite, you can feel confident that your business is secure, meaning you can get back to the things that have been sitting on your to-do list.

100questionsAuthor Commented:
I am unable to do that
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Can we assume the text file to be in CSV format at least? If so we can build a very basic HTML table:
import-csv ImportFile.csv | convertTo-HTML -Head TheTitle -as Table | Out-File Report.html

Open in new window

You can add arbitrary HTML code to that with -PreContent and -PostContent, e.g. to apply a style sheet, or whatever. Use the above code to create a file you can view in a browser to see if the layout suits you.
That is all PowerShell can give you for help. Everything else needs to be done by you, or you need to post details and examples so Experts might help you further.

As soon as the HTML code works for you, next step is sending the mail:
Send-MailMessage -SmtpServer smtp.domain.com -From me@domain.com -To you@domain.com -Subject Report -BodyAsHTML -body ((Get-Content Report.HTML) -join ' ')

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
100questionsAuthor Commented:
Thank you. Have not tried this yet however.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Email Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.