Jump to content
Macro Express Forums

Processing A Mail Form


Recommended Posts

I have a form set up for prospects to complete if they're interested in our services. The email we receive contains about 25 lines, currently formatted similar to that below but naturally I can make changes there:

field_one: prospect response

field_two: prospect response

Currently, the email arrives and I print it out, go to the form on the other website and type everything in to the other form. (I think this is faster/easier than toggling back and forth using copy/paste. At least for me.)

I have a dozen or so (small) macros already so being spoiled by ME I'm wondering what might be the best approach to at least manually run a macro on the email (I can identify it myself when it comes in - no big deal there) which then takes the information and pastes it into the form on the other website.

From the tiny bit that I know I don't think it's a csv process so what is my best approach for this?


Link to comment
Share on other sites

Thanks, Kevin.

I just spent some time going over ME Explained and what it has to share about the clipboard. I've also used the csv process before so I have some familiarity with that. I'm picturing processing the file one line at a time.


A small problem remains in that I can't just tab to the *next* field and fill that in with the next line of the csv file. After one line processed I tab 3 times to the next then maybe 6 or 8 times to the next field that must be filled in, etc. There's no consistency here from required field to required field.


Do I consider a separate csv file that contains numbers relating to the number of times it's necessary to tab to the next required file? A nested repeat? Or, do I just insert x number of line feeds in the emailed response corresponding to the number of times necessary to tab from one required field to the next so that I'm filling non-required fields with nothing? Or, does someone have a better idea?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...