On which code line is the error occurring?

Which version of Word is involved?

Are you certain the selection is in the appropriate position, when all this
starts, and that you actually have a label sheet in Word? I ask, because this
looks like macro recorder code, and recording a macro doesn't do the entire
job for creating a label sheet from scratch...

-- Cindy

"John Hutcins" wrote:

I am trying to do a Word MailMerge from within an Excel VBA macro.
This is where the macro is stopping with a Run time Error of 450 Wrong
Number of Arguments or Invalid Property Assignment. With the mail merge
wizard this is the step where it is at 'arrange labels' then select 'more
items'. This adds the Labels and VinUnit to the first field on the label
sheet.

'Layout of labels
wrd.ActiveDocument.Fields.Add Range:=Selection.Range,
Type:=wdFieldMergeField _
, Text:="""Labels"""
wrd.Selection.TypeParagraph
wrd.ActiveDocument.Fields.Add Range:=Selection.Range,
Type:=wdFieldMergeField _
, Text:="""VinUnit"""
wrd.WordBasic.MailMergePropagateLabel

Any ideas as to what is wrong?
Thanks,
John