VB Mail Merge

Hi Caspar

Here are a couple of links about mailmerging from Excel.
Say a little more what you need the macro to do.

http://www.cpearson.com/excel/Email.aspx

http://www.ozgrid.com/forum/showthread.php?t=45882

Thanks
Doug

Hi Caspar

Thanks for getting in touch. I hope you found your course useful and enjoyable.

Mail merge is perfectly possible within VBA. There are a few factors, such as where is the source data and what are merging to (e.g. labels, letters). You probably require a little knowledge on how to 'talk' to Word VBA from Excel VBA.

In Excel VBA you should go to Tools > References and add "Microsoft Office Object Library" (there will be a number in this representing the version of Office you are using). This will give you access to Word's VBA library. From then on you will need the appropriate code from recording a mail merge macro in Word.

This technique has a few twists and turns so for full information I recommend you attend our VBA Advanced course where we deal with communicating between Office applications. In the interim, I have found this decent discussion thread to give you some pointers:

http://www.ozgrid.com/forum/showthread.php?t=30692

I hope this helps, let me know how you get on.

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