How to automate some of these copy and paste tasks

Posted on 2007-10-12
Last Modified: 2010-04-16

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
But havent really look into it.

Do inform me if I have chosen the wrong categories..

A) Contents of the Email
First name : ABC
Last Name : ZXC
Email : what@hotmail
Country : UK

B) Website Sign up form
Question by:LearningLearning
    LVL 51

    Assisted Solution

    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=""}/First name/{f=$2}/Last Name/{l=$2}/Email/{e=$2}/Country/{c=$2;print "wget "u"&agree=on&_2_firstName="f"&_2_lastName="l"_2_state="c"&_2_emailAddress="e"&_2_emailAddressCfm="e}'  mbox |sh

    # the awk command above should be one single line
    # for testing you can omit the final |sh
    LVL 65

    Assisted Solution

    Hi, I used a VBScript approach here:

    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.....


    LVL 1

    Accepted Solution

    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 .

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    One of Google's most recent algorithm changes affecting local searches is entitled "The Pigeon Update." This update has dramatically enhanced search inquires for the keyword "Yelp." Google searches with the word "Yelp" included will now yield Yelp a…
    Article by: Nadia
    Suppose you use Uber application as a rider and you request a ride to go from one place to another. Your driver just arrived at the parking lot of your place. The only thing you know about the ride is the license plate number. How do you find your U…
    The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
    The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now