Mail merge-problem

I have created mail merge in word file, and data source is in excel.
My problem is whenever I open word file, every time it ask for find data
source file. Then I will have to give data source path(i.e., excel file)
I don’t want to find data source every time…is there any permanent solution
for this.
vishu

Hi Vishu,
Is your Excel file open.

Page on Mail Merge that might answer other questions
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"vishu" <[email protected]> wrote in message news:[email protected]...
> I have created mail merge in word file, and data source is in excel.
> My problem is whenever I open word file, every time it ask for find data
> source file. Then I will have to give data source path(i.e., excel file)
> I don't want to find data source every time.is there any permanent solution
> for this.
> vishu

I have gone through this link....I have not get any solution for my problem.
Please help me in this .....
Thanks in Advance.


"David McRitchie" wrote:

> Hi Vishu,
> Is your Excel file open.
>
> Page on Mail Merge that might answer other questions
> http://www.mvps.org/dmcritchie/excel/mailmerg.htm
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "vishu" <[email protected]> wrote in message news:[email protected]...
> > I have created mail merge in word file, and data source is in excel.
> > My problem is whenever I open word file, every time it ask for find data
> > source file. Then I will have to give data source path(i.e., excel file)
> > I don't want to find data source every time.is there any permanent solution
> > for this.
> > vishu
>
>
>

Vishu

How are you connecting?

If you use the DDE connection, the linked Excel document should open.
For other types of connection(ODBC e.g.) I think you have to locate the file.

Also make sure in Excel Tools>Options>General that "ignore other application"
is unchecked.

More links for mailmerge....

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

And a training tutorial for creating envelopes and labels.

http://office.microsoft.com/training...RC010390291033


Gord Dibben Excel MVP

On Sun, 17 Apr 2005 22:14:03 -0700, "vishu" <[email protected]>
wrote:

>I have gone through this link....I have not get any solution for my problem.
>Please help me in this .....
>Thanks in Advance.
>
>
>"David McRitchie" wrote:
>
>> Hi Vishu,
>> Is your Excel file open.
>>
>> Page on Mail Merge that might answer other questions
>> http://www.mvps.org/dmcritchie/excel/mailmerg.htm
>> ---
>> HTH,
>> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
>> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
>> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>>
>> "vishu" <[email protected]> wrote in message news:[email protected]...
>> > I have created mail merge in word file, and data source is in excel.
>> > My problem is whenever I open word file, every time it ask for find data
>> > source file. Then I will have to give data source path(i.e., excel file)
>> > I don't want to find data source every time.is there any permanent solution
>> > for this.
>> > vishu
>>
>>
>>