Word Fields Filled With Worksheet Data

  • Hello,

    I'm trying to get form fields in a Word document to fill automatically, via macro, from an Excel worksheet.

    I've created a custom icon on the standard toolbar for users to click, which will print invoices for each row with data in the worksheet. Essentially the macro is to be mostly automated.

    I have the following code...

    When I run the process, it stops on the second line within the With statement and says "Object Required". I'm puzzled because if I go back and look at the document the correct Stock Number is filled in from the worksheet data.

  • Re: Word Fields Filled With Worksheet Data

    Ugh, I have a problem with looking over little things often /sigh

    Works like a charm, thanks for the help!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!