Split Mail Merge & Save as Seperate Documents

Hi,

I have a set of documents which I have used to mail merge in the past and these were then printed and posted out. This year the members of the voluntary organisation that I am Chairman of have requested that we send them by email where possible.

I need a macro that will mail merge the document one document at a time and save the document using the four of the data fields namely -

<<Title>>
<<Initial>>
<<Surname>>
<<Email_Address>>

After saving close that document and move onto the next document and do the same.

I picked the following up on the internet but it goes wrong in the ActiveWorkbook.Close part of the macro and I can't work out what is going on.

Many thanks for any help

Timbo

Please Login or Register  to view this content.