sending a data source mail merge file to another computer

K

Karen Anderson

I have set up the data source merge file on one computer. Others would like
to have use of this file so that they can use my data base.

1st.. how can I send the letter with the data base that I have put together
to another computer?;
2nd it the travel was successful, how does one OPEN this file so that all
they have to do is merge from their own computer to mail out documents.

Please.. I need some help... can the data source be emailed to another
computer...

thank you
Karen
 
D

Doug Robbins - Word MVP on news.microsoft.com

All you need to do is email the mail merge main document and the data source
that is attached to it to the other people.

If you are not sure of the data source, when you have the mail merge main
document open, run a macro containing the following code and the path\name
of the data source will be displayed in a message box

MsgBox ActiveDocument.MailMerge.DataSource.Name

A data source that you created via the Mail Merge application will, by
default be stored in the following folder:

C:\Documents and Settings\[username]\My Documents\My Data Sources\

When the other users open the mail merge main document, it will not be able
to find the data source because [username] will be their user name rather
than your user name, and dialog will be displayed with the message

[DocumentName] is a mail merge main document. Word cannot find its data
source, [datasourcepath\filename]

There will also be a "Find Data Source" button on the dialog, which they can
use to browse to the data source in the location where they saved it.

--
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, originally posted via msnews.microsoft.com
 
K

Karen Anderson

Thank you so very much.. I am going to try that.. WOW.. I really do
appreciate this information...

Doug Robbins - Word MVP on news.microsof said:
All you need to do is email the mail merge main document and the data source
that is attached to it to the other people.

If you are not sure of the data source, when you have the mail merge main
document open, run a macro containing the following code and the path\name
of the data source will be displayed in a message box

MsgBox ActiveDocument.MailMerge.DataSource.Name

A data source that you created via the Mail Merge application will, by
default be stored in the following folder:

C:\Documents and Settings\[username]\My Documents\My Data Sources\

When the other users open the mail merge main document, it will not be able
to find the data source because [username] will be their user name rather
than your user name, and dialog will be displayed with the message

[DocumentName] is a mail merge main document. Word cannot find its data
source, [datasourcepath\filename]

There will also be a "Find Data Source" button on the dialog, which they can
use to browse to the data source in the location where they saved it.

--
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, originally posted via msnews.microsoft.com

Karen Anderson said:
I have set up the data source merge file on one computer. Others would
like
to have use of this file so that they can use my data base.

1st.. how can I send the letter with the data base that I have put
together
to another computer?;
2nd it the travel was successful, how does one OPEN this file so that all
they have to do is merge from their own computer to mail out documents.

Please.. I need some help... can the data source be emailed to another
computer...

thank you
Karen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top