Data into an Excel Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SamKCMO - 23 Jul 2008 01:58 GMT

I created a form in Excel 2 fields are intended to capture Employee ID# and
the other Employee Name (no need for separate fields for First & Last). I
have a list of names & ID# also in Excel which I need to create 200+
individualized forms. I would like to generate the forms without having to
type the Names & ID# into each field. Is there some sort of merge feature I
can use that will save me time? Any solutions will be greatly appreciated.

Reply to this Message

Harald Staff - 23 Jul 2008 11:46 GMT

Depending on what this is for, but if it is for print then I'd make the form
in Word and merge using the Excel list as data source. It's not too
intuitive, but well described in Word Help.

HTH. Best wishes Harald

>I created a form in Excel 2 fields are intended to capture Employee ID# and
> the other Employee Name (no need for separate fields for First & Last). I
[quoted text clipped - 5 lines]
> can use that will save me time? Any solutions will be greatly
> appreciated.

Reply to this Message

SamKCMO - 23 Jul 2008 13:15 GMT

Thanks for the quick response.

Recreating the form in Word is proving to be a difficult task b/c of all the
cell configurations and the margins don't tranfer well, the form is easier
used in Excel. Any chance of just working b/w excel documents?

> Depending on what this is for, but if it is for print then I'd make the form
> in Word and merge using the Excel list as data source. It's not too
[quoted text clipped - 11 lines]
> > can use that will save me time? Any solutions will be greatly
> > appreciated.

Reply to this Message

Harald Staff - 23 Jul 2008 19:26 GMT

Excel doesn't do "mailmerge" like Word does. But it's not clear to me what
"I need to create 200+ individualized forms" really is, so I have no other
answer ready to run. This said, one can do absolutely everything with VBA
macros, so there's always a chance.

HTH. Best wishes Harald

> Thanks for the quick response.
>
[quoted text clipped - 23 lines]
>> > can use that will save me time? Any solutions will be greatly
>> > appreciated.

Reply to this Message

Dave Peterson - 23 Jul 2008 14:34 GMT

Maybe you could use these from Debra Dalgleish's site:

http://contextures.com/xlForm02.html
and
http://contextures.com/xlForm03.html

> I created a form in Excel 2 fields are intended to capture Employee ID# and
> the other Employee Name (no need for separate fields for First & Last). I
> have a list of names & ID# also in Excel which I need to create 200+
> individualized forms. I would like to generate the forms without having to
> type the Names & ID# into each field. Is there some sort of merge feature I
> can use that will save me time? Any solutions will be greatly appreciated.

Signature

Dave Peterson

Reply to this Message