Mail Merge with moving data file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Junaid - 23 Mar 2004 22:13 GMT

Hello everyone,
I'm using Word 2000 and have a question about the logistics of Mail Merge.
I have a Form Letter generated in word and have specified the source of the
data to a tab-delimited text file. Now whenever I generate the mail merge
document, Word picks up data from the previously specified data file, which
is fine so far.

Is it possible to perform mail merge and let the Word know of another
location of the data file? I'm trying to call Word from another
non-microsoft application using OLE objects. Can I call Word and let it know
which data file to use for mail merge?

Any help would be greatly appreciated.

Thanks
Junaid

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 24 Mar 2004 01:32 GMT

Hi Junaid,

Use the [documentobject].MailMerge.OpenDataSource command

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Hello everyone,
> I'm using Word 2000 and have a question about the logistics of Mail
[quoted text clipped - 16 lines]
> Thanks
> Junaid

Reply to this Message

Junaid - 24 Mar 2004 15:14 GMT

Thanks Doug, but I have a related question though. I am opening the document
using the OLE object command Open(<document_name>) and I have an AutoOpen()
macro in the document that runs the MailMerge command. How can I pass the
data file name from the OLE object to the document so that the AutoOpen
Macro would know about it. Is there another way to achieve what I'm trying
to do. Please bear in mind that I'm not very familiar with OLE programming.
I'm actually doing this from Powerbuilder.

I really appreciate your help.

Thanks
Junaid

> Hi Junaid,
>
[quoted text clipped - 20 lines]
> > Thanks
> > Junaid

Reply to this Message