Help Sending Mail Merge Document

[dazwm]

I want to send a list of labels via email to a colleague to print. How do I? I will create the file and get the info from an excel document. If I was to print the labels, it looks at the excel file and prints fine. But how do I save it and send it if the recipient does not have the excel document. I have tried before and it only prints the first page when there could be 50!? Thanks.

[macropod]

If you 'Finish' the merge, sending the output to a new document, you can then save & attach that document to an email.

[dazwm]

Sorry I don't understand 'sending the output to a new document ' and what about the excel file it has got all the info from?

[macropod]

Did you try it? If you complete the merge as described, Word produces a document with all the labels in-situ. That document has no further need of the data source.

[dazwm]

I have tried but the recipient can only print the first page.

[macropod]

That suggests you didn't Finish the merge, but only sent a Preview. These are entirely different things... If you Finish the merge, you will see a new document containing all the records.

[dazwm]

I am using 2007 and there is an option for finish and merge. But in the drop down list there are only choices of edit individual documants, print documents or send email messages. Which one do I select to get the 'new document containing all the records'? Thanks.

[macropod]

Since you don't want to print the output you'd use 'edit individual documents' - for all records.

[dazwm]

Thanks for your help macropod. I did edit documents then done 'save as' and it seemed to work.