Macro - I got a problem?

I tested the macro enabled mail merge today.

I only get one email sent?

I did it to a test account. All of the email receipients have the same email.

1) Do I have to input {MERGEFIELD Data} multiple times into my email merge main document? ... in order to get multiple entries?

2) Do i have to have the email merge main document connected to the same data source as the macro enabled directory?

3) The directory isnt set up to have multiple fields for each row...i.e. i havent transposed the rows...that's what im trying to get around.

So cannot see the directory needing multiple {MERGEFIELD INV_Ref} etc.

I hope you've heard of this before?

Thanks