Reply
 
Thread Tools Display Modes
  #1   Report Post  
TedRusky
 
Posts: n/a
Default Can I e-mail a mail merge document?

If I e-mail a word document that I have created with merge fields (Office
2002, Windows Xp Pro) will the recipient of the e-mail be able to toggle
through the merged fields as well?

Another way of phrasing this quesiton is whether mail merge saves the merge
information as part of the document or if mail merge is directing the SQL
command to a source (i.e. database or Excel file).
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

If you send the mail merge /main document/ as an attachment to your e-mail,
then your recipient should be able to open it.

If they have a mail merge data source that has exactly the same pathname as
yours, they /may/ be able to open their document with few problems, and when
they preview or merge, they will see /their/ data. if you selected/rejected
individual records in "Mail Merge Recipients", that might have an impact on
what they saw - I do not know, but I suggest you don't rely on any such
selections/rejections.

However, Word may not be able to open that data source, even if it has
exactly the same name and path. If not, it will prompt for a new data
source, and then you have lost control.

Peter Jamieson

"TedRusky" wrote in message
...
If I e-mail a word document that I have created with merge fields (Office
2002, Windows Xp Pro) will the recipient of the e-mail be able to toggle
through the merged fields as well?

Another way of phrasing this quesiton is whether mail merge saves the
merge
information as part of the document or if mail merge is directing the SQL
command to a source (i.e. database or Excel file).



  #3   Report Post  
TedRusky
 
Posts: n/a
Default

Thank you for taking the time to respond. If I understand correctly, the
main document saves the merge fields but the data itself is not saved. The
recipient will need to have access to the data source as well.


"Peter Jamieson" wrote:

If you send the mail merge /main document/ as an attachment to your e-mail,
then your recipient should be able to open it.

If they have a mail merge data source that has exactly the same pathname as
yours, they /may/ be able to open their document with few problems, and when
they preview or merge, they will see /their/ data. if you selected/rejected
individual records in "Mail Merge Recipients", that might have an impact on
what they saw - I do not know, but I suggest you don't rely on any such
selections/rejections.

However, Word may not be able to open that data source, even if it has
exactly the same name and path. If not, it will prompt for a new data
source, and then you have lost control.

Peter Jamieson

"TedRusky" wrote in message
...
If I e-mail a word document that I have created with merge fields (Office
2002, Windows Xp Pro) will the recipient of the e-mail be able to toggle
through the merged fields as well?

Another way of phrasing this quesiton is whether mail merge saves the
merge
information as part of the document or if mail merge is directing the SQL
command to a source (i.e. database or Excel file).




  #4   Report Post  
Peter Jamieson
 
Posts: n/a
Default

You probably got it. But just to clarify, in case...

The mail merge main document does contain information about the data source,
and it also tries to remember which record you were previewing in the data
source when you saved the document. But that information is essentially to
do with the data source that /your/ machine sees. If, for example, it is an
Access database at c:\mydbs\mydb.mdb, when they open the document, Word will
try to connect to \their\ c:mydbs\mydb.mdb, which might be a completely
different database with different tables, fields and data. So...

The
recipient will need to have access to the data source as well.


The recipient needs access to the data source that they need to complete the
merge. If every recipient needs the same data, you either have to provide
access to the same central data, or you have to provide copies of the same
data to each recipient. If the point is that each recipient is using the
same data structures (same tables etc.) but has dffierent data in their
local database, all you really need to be concerned about is that the merge
document either works when each recipient opens it, or that each recipient
knows how to connect the document to their own local data.

Peter Jamieson


"TedRusky" wrote in message
...
Thank you for taking the time to respond. If I understand correctly, the
main document saves the merge fields but the data itself is not saved. The
recipient will need to have access to the data source as well.


"Peter Jamieson" wrote:

If you send the mail merge /main document/ as an attachment to your
e-mail,
then your recipient should be able to open it.

If they have a mail merge data source that has exactly the same pathname
as
yours, they /may/ be able to open their document with few problems, and
when
they preview or merge, they will see /their/ data. if you
selected/rejected
individual records in "Mail Merge Recipients", that might have an impact
on
what they saw - I do not know, but I suggest you don't rely on any such
selections/rejections.

However, Word may not be able to open that data source, even if it has
exactly the same name and path. If not, it will prompt for a new data
source, and then you have lost control.

Peter Jamieson

"TedRusky" wrote in message
...
If I e-mail a word document that I have created with merge fields
(Office
2002, Windows Xp Pro) will the recipient of the e-mail be able to
toggle
through the merged fields as well?

Another way of phrasing this quesiton is whether mail merge saves the
merge
information as part of the document or if mail merge is directing the
SQL
command to a source (i.e. database or Excel file).






  #5   Report Post  
TedRusky
 
Posts: n/a
Default

Thank you!

"Peter Jamieson" wrote:

You probably got it. But just to clarify, in case...

The mail merge main document does contain information about the data source,
and it also tries to remember which record you were previewing in the data
source when you saved the document. But that information is essentially to
do with the data source that /your/ machine sees. If, for example, it is an
Access database at c:\mydbs\mydb.mdb, when they open the document, Word will
try to connect to \their\ c:mydbs\mydb.mdb, which might be a completely
different database with different tables, fields and data. So...

The
recipient will need to have access to the data source as well.


The recipient needs access to the data source that they need to complete the
merge. If every recipient needs the same data, you either have to provide
access to the same central data, or you have to provide copies of the same
data to each recipient. If the point is that each recipient is using the
same data structures (same tables etc.) but has dffierent data in their
local database, all you really need to be concerned about is that the merge
document either works when each recipient opens it, or that each recipient
knows how to connect the document to their own local data.

Peter Jamieson


"TedRusky" wrote in message
...
Thank you for taking the time to respond. If I understand correctly, the
main document saves the merge fields but the data itself is not saved. The
recipient will need to have access to the data source as well.


"Peter Jamieson" wrote:

If you send the mail merge /main document/ as an attachment to your
e-mail,
then your recipient should be able to open it.

If they have a mail merge data source that has exactly the same pathname
as
yours, they /may/ be able to open their document with few problems, and
when
they preview or merge, they will see /their/ data. if you
selected/rejected
individual records in "Mail Merge Recipients", that might have an impact
on
what they saw - I do not know, but I suggest you don't rely on any such
selections/rejections.

However, Word may not be able to open that data source, even if it has
exactly the same name and path. If not, it will prompt for a new data
source, and then you have lost control.

Peter Jamieson

"TedRusky" wrote in message
...
If I e-mail a word document that I have created with merge fields
(Office
2002, Windows Xp Pro) will the recipient of the e-mail be able to
toggle
through the merged fields as well?

Another way of phrasing this quesiton is whether mail merge saves the
merge
information as part of the document or if mail merge is directing the
SQL
command to a source (i.e. database or Excel file).






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
Mail Merge Errors1 document created after merge Ron Mailmerge 1 June 10th 05 08:37 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
save individual letters from a mail merge document Horta Mailmerge 6 March 25th 05 04:19 PM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Mail merge to append / create a document? ScottAtMU Mailmerge 1 January 5th 05 04:44 AM


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

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

About Us

"It's about Microsoft Word"