Jon

Of course using VBA is more flexible, but it wasn't 100% clear what the OP was doing.

I just thought I'd through in the idea of Mail Merge as I don't see any point in re-inventing the wheel when you have built-in functionality that might achieve your objective.

Perhaps in this case VBA is the way to go, but I just thought I'd make the suggestion.

Edit: I've just reread the OP's last post.

Sounds to me like Mail Merge could be used.