R
Ron H
Using a CSV data source, in word 2000 VBA, I have been attempting to merge individual rows to separate documents and then e-mail each resulting document via Outlook to the recipient. I have had success with the merge, but the e-mail fails with "Microsoft Visual Basic Run-time error '5630'. The text of it is: "Word cannot merge documents that can be distributed by mail or fax without a valid mail address. Choose the Setup button to select a mail address data field."
The problem is I don't know where the Setup button is or how to establish a valid mail address.
In the VBA code I have included the .MailAddressFieldName = "rhait", .Destination = wdSendToEmail, .MailAsAttachment = True and .MailSubject = "Merged Output" properties. When the .Execute command runs, the error occurs.
I have also tried saving the merged document and then sending the active document via ActiveDocument.SendMail, but this stops at a prompt looking for the recipient e-mail address.
What am I missing?
The problem is I don't know where the Setup button is or how to establish a valid mail address.
In the VBA code I have included the .MailAddressFieldName = "rhait", .Destination = wdSendToEmail, .MailAsAttachment = True and .MailSubject = "Merged Output" properties. When the .Execute command runs, the error occurs.
I have also tried saving the merged document and then sending the active document via ActiveDocument.SendMail, but this stops at a prompt looking for the recipient e-mail address.
What am I missing?