Automating Mail Merge with Macro

[gxm100]

Hi All,

I have a mail merge set up between an excel doc and a word doc. I would like to use the excel info to populate the word document, but want to be able to select which row to populate it with. I have the mail merge set up, and I have a macro written to create an Input Box asking for a Booking Number which will then pull over the relevant info. It works, but only for the first row of the excel document and I'm not sure why that is. Below is the macro I presently have written

Please Login or Register  to view this content.

[macropod]

Aside from the fact your VBA code doesn't set the merge record correctly and never executes the merge, you don't actually need VBA for this. In any event, being a docx file, your mailmerge main document cannot contain a macro. All you need is an appropriately-coded SKIPIF field in the mailmerge main document. See attached.