Mailmerge macro changes needed

Hi,

I am using the following code to perform mailmerge and save as individual doc in a separate folder.

Please Login or Register  to view this content.

The problem is like the saved document format is different when compared to the mailmerge template. Instead of creating a new document and pasting it, all I need is mailmerge and save as a new document.

I am new to VBA and I need to know what are the changes to be made.

Attached is the sample file with the output in the output folder.

Can someone help me please

If you need further details, please post

Thanks,
aganesan99

Hi aganesan99

The issue appears to be that the New Word Documents are being created with 8 1/2 by 11 paper and with Paragraph Spacing of 10 pts. These lines of Code fix that issue. Your Font Formatting is also not the same...there MAY be a way to fix that...haven't pursued it.

Please Login or Register  to view this content.

Full Code

Please Login or Register  to view this content.

Hi aganesan99

This should get you pretty close.

Add these two Dim Statements

Please Login or Register  to view this content.

Add these lines of Code

Please Login or Register  to view this content.

Entire Code

Please Login or Register  to view this content.