Hi
I have a friend who is doing data entry.
He need to copy all the field data from Email (refer A below), then paste in a website sign up form (refer B below).
How can we automate the processes?
Example, one click in email, then it will copy all the field data, then another one click it will automatically fill up all the field in website form. We are not looking for 100% automated. But at least minimize the works.
I am totally noob in scripting nor programming.
But wondering is there a way we can do this.
I did came across a macro program in www.macroexpress.com.
But havent really look into it.
p/s:
Do inform me if I have chosen the wrong categories..
thanks!
A) Contents of the Email
--------------------------
First name : ABC
Last Name : ZXC
Email : what@hotmail
Country : UK
B) Website Sign up form
--------------------------
Refer: http://tinyurl.com/25va7q
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi, I used a VBScript approach here:
http://www.experts-exchang
which can also fill in text fields. If you're using Outlook, that code can be adapted into a Macro, with the Microsoft Scripting Runtime added as a reference....and we can try to get the required text out of the email.....
Regards,
Rob.
The problem with macroexpress, is that it costs $$. And if it doen't work for you, your out the money.
Try out "Autohotkey", it's FREE (GNU/GPL), yet powerful ! Its available at www.autohotkey.com .
I have been using it for some months now to automate my order entry into my accounting package, and then the subsequent order processing into my virtual terminal. It is saving me a ton of time. I just hit the macro key combination, and away it goes (although I still have to have the text cursor in the correct fields/postion before doing that).
You can start out by just using the simple macro recorder (it's best to just use keystrokes instead of the mouse, more consistant then). Then it looks like you'll probably have to modify the script a little by writing a few parsing routines (they have tons of pre-made functions/routines you can DL from their site). Once your done testing your script, you can even compile it into a standalone runtime (just needs a DLL to run).
It's been extended quite a bit, from its original "macro recorder" purpose, as you can pretty much do a full fleged program with if you wanted to. Very BASIC like in language structure, so its easy to learn. It runs on any 32bit windows machine.
Business Accounts
Answer for Membership
by: ahoffmannPosted on 2007-10-12 at 02:02:59ID: 20063869
assuming your mail is in a file named mbox and the data there is exactly as you described in A), then following might work:
awk -F: 'BEGIN{u="https://www.aglo
# the awk command above should be one single line
# for testing you can omit the final |sh