I have no idea. HELP

K

ksawb

I have no idea what I'm doing or how to fix it. Someone made some forms
years ago. Now something is wrong with them and I've been asked to fix it.
The person that made the form is not here. I'm getting error reports and when
I tell it to debug this pops up. and the polnum = .DataFields("... is yellow
with a small yellow arrow.

What do I do about it?

With ActiveDocument.MailMerge.DataSource
.ActiveRecord = wdFirstRecord
Agenttest = .DataFields("Agent").Value
polnum = .DataFields("PolNum").Value
sdate = .DataFields("startDate").Value
edate = .DataFields("endDate").Value
'checkadd1 = .DataFields("Address1").Value
'checkadd2 = .DataFields("Address2").Value
End With
 
K

Kelw

I have no idea what I'm doing or how to fix it. Someone made some forms
years ago. Now something is wrong with them and I've been asked to fix it.
The person that made the form is not here. I'm getting error reports and when
I tell it to debug this pops up. and the polnum = .DataFields("... is yellow
with a small yellow arrow.

What do I do about it?

With ActiveDocument.MailMerge.DataSource
.ActiveRecord = wdFirstRecord
Agenttest = .DataFields("Agent").Value
polnum = .DataFields("PolNum").Value
sdate = .DataFields("startDate").Value
edate = .DataFields("endDate").Value
'checkadd1 = .DataFields("Address1").Value
'checkadd2 = .DataFields("Address2").Value
End With


The yellow highlight and the yellow arrow means that this is the line
that is causing the error.

It probably cannot get a value from the DataField called "PolNum",
which may mean that it no longer exists, or has been renamed. I would
start there.
 
R

Russ

K,
You should tell us what the error message reported.
Do you still have a Record field named PolNum in your data source file?

Read how to use mailmerge in Word Help menu.

There is also this forum available:
microsoft.public.word.mailmerge.fields
 

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