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.

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


"SamKCMO" <SamKCMO@discussions.microsoft.com> wrote in message
news:2472A825-C027-4C84-864B-AFAD9B779CF2@microsoft.com...
>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.

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?

"Harald Staff" wrote:

> 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
>
>
> "SamKCMO" <SamKCMO@discussions.microsoft.com> wrote in message
> news:2472A825-C027-4C84-864B-AFAD9B779CF2@microsoft.com...
> >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.
>
>

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

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

SamKCMO wrote:
>
> 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.

--

Dave Peterson

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


"SamKCMO" <SamKCMO@discussions.microsoft.com> wrote in message
news:AB598978-A559-4FA6-8054-592D82D88F7C@microsoft.com...
> 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?
>
> "Harald Staff" wrote:
>
>> 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
>>
>>
>> "SamKCMO" <SamKCMO@discussions.microsoft.com> wrote in message
>> news:2472A825-C027-4C84-864B-AFAD9B779CF2@microsoft.com...
>> >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.
>>
>>