Caspar has attended:
Excel VBA Intro Intermediate course
VB Mail Merge
Hopefully just a quick question:
When using VB with a mail merge, is there a standard way of saying
'execute this sub automatically as the merged document is brought up after the mail merge rather than waiting for a user to run it'?
RE: 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
RE: VB Mail Merge
Thanks for your prompt response. I've had no difficulty with the drop downs and clicking, but the subsequent macros do not seem to run automatically when the merge output opens.
Should it be
Private Sub Workbook_Open()
End Sub
Sub MyMacro()
...
...
End Sub
or
'Private Sub Workbook_Open()' instead of the text 'Sub MyMacro()' and then End Sub?
RE: VB Mail Merge
Hi Caspar
Just to be clear, it should look like this:
Private Sub Workbook_Open()
...
<mail merge code goes here>
...
End Sub
Does that help?
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
