Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / November 2007

Tip: Looking for answers? Try searching our database.

I have no idea.  HELP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ksawb - 01 Nov 2007 16:45 GMT
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
Kelw - 01 Nov 2007 17:02 GMT
> 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.  
[quoted text clipped - 13 lines]
>     '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.
Russ - 04 Nov 2007 07:51 GMT
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

> 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.
[quoted text clipped - 13 lines]
>     'checkadd2 = .DataFields("Address2").Value
>   End With

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.