print envelope macro

[kms1234]

I have a merged document of 300 letters. i tried creating a macro that will copy the three lines after the cursor, and print the envelope with the copied address. however, when i run the macro it just prints the text from when i recorded the macro it doesn't print the newly selected address. How can i do this?

 

[VBAjedi]

I wouldn't bother with a macro - just use whatever data source you used to do the merge to set up a second merge just for envelopes (using Tools>Envelopes and Labels).

VBAjedi

 

[kms1234]

I don't have the original data source!