Help required for enable me to run a mail merge

[markyc]

Hi all.

I have a excel spreadsheet with lists of policy numbers in column A with various dates and information headings going across the sheet

I am trying to set up a mail merge macro that will enable me to do the following:

1. A inputbox to popup asking user to enter policy number.
2. Once policy number entered the word mail merge doc is opened and only the policy number entered above is merged and printed out.
3. Word is closed, not saving changes, and returns to the excel spreadsheet.

Any help will be great

Regards:help

[mdmackillop]

Hi Mark,
There are some mailmerge items in the KB that can probably be modified to your requirements. Have you checked there?

[markyc]

Thanks for this will have look through

Rgds

Mark