automated input of form info into a table

E

edgy

Hi,
Sorry for the crosspost, not sure where I should ask this...

I receive info from a webform to my email, and I would like to be able to
open this info and have it automatically go into the appropriate cell of a
table in Word.

i.e. my received information would look like this:

Company Name: ABC inc.
Phone #: 555-5555
Address: 90210 Beverly Hills CA
Fax #: 666-6666
Contact Person: Joe
email: (e-mail address removed)
Quantity 1: 3
Description 1: Trees
Size 1: 80mm
Price 1: 100.00
Total 1: 300.00
Quantity 2: 5
etc....

is this possible? Basically, can I set up a macro or template (sorry, Im
not sure of the terminology to use here) that would be able to merge this
info into my existing table (minus the "Company Name:", etc.?

Also, I can play with the settings at the server end that I only receive the
user-inputted info delimited by "enter" if this would make it simpler.

i.e.
ABC inc.
555-5555
90210 Beverly Hills CA
666-6666

any help would be much appreciated!
 
D

Doug Robbins - Word MVP

It should be possible with a bit of VBA code tailored for the job.

It is not however a mailmerge type exercise.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
E

edgy

Doug Robbins - Word MVP said:
It should be possible with a bit of VBA code tailored for the job.

It is not however a mailmerge type exercise.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP


Thanks...was able to set up a macro with visual basic with some help from
elsewhere!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top