Merge form word doc w Excel data & email

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

relo - 29 May 2008 20:22 GMT

Hello

I created a form in Word03. I merge data from Excel03. I want to emial the
form to specific names in the spreadsheet. I have set this all up and the
merge works great. BUT, when I email the form from Outlook the form does not
work for the recipient. The merge is good, it gives the right data but the
check boxes and text fields don't work and people can't fill the form out. I
have to do each one manually then send as an attachement. Even then sometimes
people tell me they can't open the attachments. Any ideas???

Reply to this Message

Doug Robbins - Word MVP - 29 May 2008 20:35 GMT

FormFields as used in a protected document and mail merge are not
compatible. You would have to use a "roll-your-own" equivalent to mailmerge
using a template containing docvariable fields to contain the data from the
data source and have a macro iterate through the data source, creating a new
document from the template for each record and setting the values of
variables in that document to the data for that record, updating the fields
and then emailing the document.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hello
>
[quoted text clipped - 8 lines]
> sometimes
> people tell me they can't open the attachments. Any ideas???

Reply to this Message