98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA/MS Word Mail Merge Not Working
Excel VBA/MS Word Mail Merge Not Working
Resolved · High Priority · Version 2007
Richard has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Excel VBA/MS Word Mail Merge Not Working
Hi.
I am not sure if my issue is Excel VBA or MS Mail Merge and so I hope you will be able to assist.
I have created an Excel macro which imports another file, does some fairly basic formatting, validations against other data and then compiles a table for use in an MS Word Mail Merge.
It all worked fine apart from I tried to embed the Word file as an object and received an error message saying 'Word cannot start the converter mswrd632.wpc.' - I am not sure if this has had any impact but it seems to have been from around the same time I have been getting the issue.
When I run the Mail Merge, (I have not bothgered embedding the file, I just open seperately) and I get the 'Mail Merge Recipients' window, the menu bar, for example for sorting, selecting nonblanks etc does not work. The whole bar seems to have become unusable, ie selecting all/none, drop downs do not show. My colleague tried to run the merge on his PC and it was fine, I moved my laptop to a different network point and I was able to get it to work. I then moved back and it continued to work. But then I ran a few processes again and it didn't work again. My colleague ran again and it was ok. I am unable now to use the menu bar on any Mail Merge, even a new Excel table and a new Word document.
It suggests to me possibly something different between the settings on my laptop and the PC but have no idea where to start looking. Does this sound likely or is there possibly something within my Excel code which has caused this? We are a little reluctant to run the code on the PC in case it 'breaks' that as well if it is the code.
Please could you advise of any solutions and what may have caused this?
Thank you in advance.
Richard
RE: Excel VBA/MS Word Mail Merge Not Working
Hi Richard
Thanks for getting in touch. I've not come across this particular error before, but research on Microsoft's site seems to be a problem with a file converter built into Word. There's more info, plus details on how to fix it, here:
http://support.microsoft.com/kb/973904
It seems unlikely that the macro is causing it, but if you want to send over the macro to gary@stl-training.co.uk I'll happily take a look. Alternatively paste the code into here.
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
Wed 28 Aug 2013: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding a comment to a formula1. At the end of the formula, add a + (plus) sign.
|