Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
relo relo is offline
external usenet poster
 
Posts: 2
Default Merge form word doc w Excel data & email

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???
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Merge form word doc w Excel data & email

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.

--
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

"relo" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking a Word form with merge data back to Excel James C Mailmerge 1 March 13th 08 03:50 PM
Merge Excel data into specific form areas in a Word Doc duugg Microsoft Word Help 1 May 4th 06 10:27 AM
Merge Excel Data to Word documents then email individual letters MarvInBoise Mailmerge 8 April 29th 06 01:04 AM
Excel data for email merge in Word 2000 Kevin Mailmerge 1 October 18th 05 09:11 PM
Word 2003 Email Merge w/Excel Data [email protected] Mailmerge 1 June 17th 05 11:46 PM


All times are GMT +1. The time now is 04:15 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"