mail merge macro error

B

Bernie Yaeger

I'm having trouble with a simple mail merge macro - I
create the macro with the macro recorder. All I want to
do is take an open document as source document, open a
table in sql server, paste in a few fields and then merge
into letters to all recipients.

It works fine when I do it interactively. But when I run
the macro, I get the error 'record 1 contained too few
data fields', 'record 2 contained too few data fields',
etc. and the merge file does not get created. Any ideas
why this is happening?

Tx for your help.

Bernie Yaeger
 
P

Peter Jamieson

Please open up the macro editor and find and copy the OpenDataSource
statement and post it in a message in this thread?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top