Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2006

Tip: Looking for answers? Try searching our database.

automated input of form info into a table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
edgy - 17 Aug 2006 21:13 GMT
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: address@yahoo.com
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!
Doug Robbins - Word MVP - 18 Aug 2006 04:44 GMT
It should be possible with a bit of VBA code tailored for the job.

It is not however a mailmerge type exercise.

Signature

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

> Hi,
> Sorry for the crosspost, not sure where I should ask this...
[quoted text clipped - 33 lines]
>
> any help would be much appreciated!
edgy - 18 Aug 2006 21:23 GMT
> It should be possible with a bit of VBA code tailored for the job.
>
[quoted text clipped - 38 lines]
>>
>> any help would be much appreciated!

Thanks...was able to set up a macro with visual basic with some help from
elsewhere!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.