View Single Post
  #5 (permalink)  
Old 07-23-2008, 07:26 PM
Harald Staff
 
Posts: n/a
Re: Data into an Excel Form

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.

>>
>>


Reply With Quote