字vba [英] word vba

查看:74
本文介绍了字vba的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我在我的网站上发了一个表单,在提交时通过电子邮件发送给我。我想把它变成HR的可读格式。就像现在一样,我有:

日期:2007年1月17日

职位:任何

最后:打击

第一:joe

我这样做的最佳方式是什么,xml,导入到表单?任何帮助都会很棒。谢谢

I have made a form on my website that emails me when submitted. I want to turn this into a readable format for HR. as now, I have:
date:1/17/2007
position:any
last:blow
first:joe
What is the best way for me to do this, xml, import to form? any help would be great. Thanks

推荐答案

我假设您要将其导入表格。

Access将允许您创建到Outlook文件夹的链接表。

问题是数据是多行的事实。

格式:

数据,:01-01 -2007,Joe,Blow

允许使用Split()函数获取碎片并将其放入表中。

多行使此复杂化。


Nic; o)
I assume you want to import this into a table.
Access will allow you to create a linked table to an outlook folder.
The problem hoever will be the fact that the data is in multiple rows.
Having a format:
Data,: 01-01-2007, Joe, Blow
Would allow to use the Split() function to get the pieces and drop that into a table.
Multiple rows complicate this.

Nic;o)



我在我的网站上发了一个表格,在提交时通过电子邮件发送给我。我想把它变成HR的可读格式。就像现在一样,我有:

日期:2007年1月17日

职位:任何

最后:打击

第一:joe

我这样做的最佳方式是什么,xml,导入到表单?任何帮助都会很棒。谢谢
I have made a form on my website that emails me when submitted. I want to turn this into a readable format for HR. as now, I have:
date:1/17/2007
position:any
last:blow
first:joe
What is the best way for me to do this, xml, import to form? any help would be great. Thanks



我无法看到Access或Word是如何形成的。

这不是关于服务器端的功能脚本引擎(我很遗憾地知道v很少)? VB脚本或Java?

我可能完全错了 - 我担心这个问题本身并不是很清楚。如果我错了,请忽略我,否则我认为在Java论坛上发帖可能会有所帮助。如果您正在使用VB Script,那么他们也可以在那里获得一些专业知识。

他们可能能够告诉您将最简单的格式附加到电子邮件中。它可能是我认为的MS Word - 如果可以从那里获得库。我不知道。

I can''t see how Access or Word come into this.
Would this not be about the capabilities of the server side script engine (of which I sadly know v little)? VB Script or Java?
I may be on the wrong lines completely - I''m afraid the question itself isn''t very clear. If I''m wrong then please ignore me, otherwise I would think that posting in the Java forum might help. If you''re using VB Script then they may have some expertise in there for that too.
They may be able to tell you what is the simplest format to attach it to the e-mail with. It may be that it''s MS Word I suppose - if libraries are available from there. I don''t know.


这些字段实际上是分开的。我从未想过将它带入Access。我可以为HR构建一个简单的数据库,以便他们可以导入并根据我们的喜好进行报告。我将研究Split函数
these fields actually come in on seperate lines. I never thought about bringing it into Access. I could build a simple database for HR to use so they can import and make a report to our liking. I will look into the Split function


这篇关于字vba的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆