VB Mail Merge

Hi

Thanks for getting in touch. Assuming you start your mail merge process in Excel, where you usually start a macro with

sub MyMacro()

You should have something like this

Private Sub Workbook_Open()

To recreate this code you can go to your Project Explorer in the VBE, select the ThisWorkbook object, then over the top of your code are two drop-downs. In the first select Workbook, and the second Open.

I hope this helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector