Group:  Microsoft Word ยป microsoft.public.word.vba.beginners
Thread: Mail merge in office 2007

Mail merge in office 2007
Priya 10/29/2008 9:54:00 AM
My requirement is to create the mailmerge documents in office 2007 formats
i.e. using .docx and .docm. I am using a template for the same. I have
changed my template name from .dot to .dotm. I am saving the header document
as .docx and main document as .docm

when I try to reopen the mail merged main document, i am getting the
following error "The Office Open XML File cannot be opened because there are
problems with the contents". Please can this be sorted out. Does mailmerge
work with the office 2007 formats?

Re: Mail merge in office 2007
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 10/29/2008 7:35:55 PM
How did you change the template from .dot to .dotm? Simply by changing the
file name will not work. You would have to open the template using
File>Open and then use File>Save As and in the File Save As dialog, change
the the document type to Word Macro-Enabled Template (*.dotm).

However, are there any macros in the original template that require it to be
a macro-enabled template.

A final question is why do you need this to be in Office 2007 format? Word
2007 can use files in earlier formats for mail merge. If it ain't broke,
don't fix 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

"Priya" <Priya[ at ]discussions.microsoft.com> wrote in message
news:EBD2ABD3-1CD4-4B20-AD2D-15FB68B8CB6D[ at ]microsoft.com...
[Quoted Text]
> My requirement is to create the mailmerge documents in office 2007 formats
> i.e. using .docx and .docm. I am using a template for the same. I have
> changed my template name from .dot to .dotm. I am saving the header
> document
> as .docx and main document as .docm
>
> when I try to reopen the mail merged main document, i am getting the
> following error "The Office Open XML File cannot be opened because there
> are
> problems with the contents". Please can this be sorted out. Does mailmerge
> work with the office 2007 formats?
>


Re: Mail merge in office 2007
Priya 10/30/2008 9:39:01 AM
Doug,

Many thanks for this. I have saved the template, as you have specified. My
clients require everything in office 2007 formats.

Is there any way to do the same. I am new to this newsgroup and also VBA.
Please help me out to solve this.

Thanks,
Priya.

"Doug Robbins - Word MVP" wrote:

[Quoted Text]
> How did you change the template from .dot to .dotm? Simply by changing the
> file name will not work. You would have to open the template using
> File>Open and then use File>Save As and in the File Save As dialog, change
> the the document type to Word Macro-Enabled Template (*.dotm).
>
> However, are there any macros in the original template that require it to be
> a macro-enabled template.
>
> A final question is why do you need this to be in Office 2007 format? Word
> 2007 can use files in earlier formats for mail merge. If it ain't broke,
> don't fix 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
>
> "Priya" <Priya[ at ]discussions.microsoft.com> wrote in message
> news:EBD2ABD3-1CD4-4B20-AD2D-15FB68B8CB6D[ at ]microsoft.com...
> > My requirement is to create the mailmerge documents in office 2007 formats
> > i.e. using .docx and .docm. I am using a template for the same. I have
> > changed my template name from .dot to .dotm. I am saving the header
> > document
> > as .docx and main document as .docm
> >
> > when I try to reopen the mail merged main document, i am getting the
> > following error "The Office Open XML File cannot be opened because there
> > are
> > problems with the contents". Please can this be sorted out. Does mailmerge
> > work with the office 2007 formats?
> >
>
>
>
Re: Mail merge in office 2007
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 10/30/2008 11:57:13 AM
I am not quite sure where you are with this now.

Exactly what do you mean by "Is there any way to do the same."?

As asked previously, do you need to use the docm and dotm formats? Are
there any macros involved in what you are doing?

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

"Priya" <Priya[ at ]discussions.microsoft.com> wrote in message
news:451143A5-08E7-470E-B482-305427C3DB89[ at ]microsoft.com...
[Quoted Text]
> Doug,
>
> Many thanks for this. I have saved the template, as you have specified.
> My
> clients require everything in office 2007 formats.
>
> Is there any way to do the same. I am new to this newsgroup and also VBA.
> Please help me out to solve this.
>
> Thanks,
> Priya.
>
> "Doug Robbins - Word MVP" wrote:
>
>> How did you change the template from .dot to .dotm? Simply by changing
>> the
>> file name will not work. You would have to open the template using
>> File>Open and then use File>Save As and in the File Save As dialog,
>> change
>> the the document type to Word Macro-Enabled Template (*.dotm).
>>
>> However, are there any macros in the original template that require it to
>> be
>> a macro-enabled template.
>>
>> A final question is why do you need this to be in Office 2007 format?
>> Word
>> 2007 can use files in earlier formats for mail merge. If it ain't broke,
>> don't fix 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
>>
>> "Priya" <Priya[ at ]discussions.microsoft.com> wrote in message
>> news:EBD2ABD3-1CD4-4B20-AD2D-15FB68B8CB6D[ at ]microsoft.com...
>> > My requirement is to create the mailmerge documents in office 2007
>> > formats
>> > i.e. using .docx and .docm. I am using a template for the same. I have
>> > changed my template name from .dot to .dotm. I am saving the header
>> > document
>> > as .docx and main document as .docm
>> >
>> > when I try to reopen the mail merged main document, i am getting the
>> > following error "The Office Open XML File cannot be opened because
>> > there
>> > are
>> > problems with the contents". Please can this be sorted out. Does
>> > mailmerge
>> > work with the office 2007 formats?
>> >
>>
>>
>>


Re: Mail merge in office 2007
Priya 10/30/2008 12:43:01 PM
Yes I am using a macro enabled template(.dotm). The mailmerge we are using
works as follows
1) Create a header document using a .inc file(.inc file is created from the
client system). The header document will have the datafield names.
2) Create the main document. I will select the header document during
mailmerge(select recepients).
3) finally from the client system we will just run a program that connects
these two documents with the database and gives us the mailmerge documents.

For step 1 and 2 I use the .dotm template.
I need to save the header and main documents as either .docx or .docm, as
the clients don't want them to be saved in word 97 - 2003 formats.

Please let me know if you need more information.

I am also facing another issue. As soon as I place my template in the
startup folder for Word, I am not able to use the File/Save As option. this
is existing from office 2000 version.

Thanks,
Akila

"Doug Robbins - Word MVP" wrote:

[Quoted Text]
> I am not quite sure where you are with this now.
>
> Exactly what do you mean by "Is there any way to do the same."?
>
> As asked previously, do you need to use the docm and dotm formats? Are
> there any macros involved in what you are doing?
>
> --
> 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
>
> "Priya" <Priya[ at ]discussions.microsoft.com> wrote in message
> news:451143A5-08E7-470E-B482-305427C3DB89[ at ]microsoft.com...
> > Doug,
> >
> > Many thanks for this. I have saved the template, as you have specified.
> > My
> > clients require everything in office 2007 formats.
> >
> > Is there any way to do the same. I am new to this newsgroup and also VBA.
> > Please help me out to solve this.
> >
> > Thanks,
> > Priya.
> >
> > "Doug Robbins - Word MVP" wrote:
> >
> >> How did you change the template from .dot to .dotm? Simply by changing
> >> the
> >> file name will not work. You would have to open the template using
> >> File>Open and then use File>Save As and in the File Save As dialog,
> >> change
> >> the the document type to Word Macro-Enabled Template (*.dotm).
> >>
> >> However, are there any macros in the original template that require it to
> >> be
> >> a macro-enabled template.
> >>
> >> A final question is why do you need this to be in Office 2007 format?
> >> Word
> >> 2007 can use files in earlier formats for mail merge. If it ain't broke,
> >> don't fix 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
> >>
> >> "Priya" <Priya[ at ]discussions.microsoft.com> wrote in message
> >> news:EBD2ABD3-1CD4-4B20-AD2D-15FB68B8CB6D[ at ]microsoft.com...
> >> > My requirement is to create the mailmerge documents in office 2007
> >> > formats
> >> > i.e. using .docx and .docm. I am using a template for the same. I have
> >> > changed my template name from .dot to .dotm. I am saving the header
> >> > document
> >> > as .docx and main document as .docm
> >> >
> >> > when I try to reopen the mail merged main document, i am getting the
> >> > following error "The Office Open XML File cannot be opened because
> >> > there
> >> > are
> >> > problems with the contents". Please can this be sorted out. Does
> >> > mailmerge
> >> > work with the office 2007 formats?
> >> >
> >>
> >>
> >>
>
>
>
Re: Mail merge in office 2007
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/2/2008 6:14:53 AM
Show us all of the code that you are using in your template.

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

"Priya" <Priya[ at ]discussions.microsoft.com> wrote in message
news:8E629DB4-5278-441F-8C1E-5DFCBC6D02A3[ at ]microsoft.com...
[Quoted Text]
> Yes I am using a macro enabled template(.dotm). The mailmerge we are using
> works as follows
> 1) Create a header document using a .inc file(.inc file is created from
> the
> client system). The header document will have the datafield names.
> 2) Create the main document. I will select the header document during
> mailmerge(select recepients).
> 3) finally from the client system we will just run a program that connects
> these two documents with the database and gives us the mailmerge
> documents.
>
> For step 1 and 2 I use the .dotm template.
> I need to save the header and main documents as either .docx or .docm, as
> the clients don't want them to be saved in word 97 - 2003 formats.
>
> Please let me know if you need more information.
>
> I am also facing another issue. As soon as I place my template in the
> startup folder for Word, I am not able to use the File/Save As option.
> this
> is existing from office 2000 version.
>
> Thanks,
> Akila
>
> "Doug Robbins - Word MVP" wrote:
>
>> I am not quite sure where you are with this now.
>>
>> Exactly what do you mean by "Is there any way to do the same."?
>>
>> As asked previously, do you need to use the docm and dotm formats? Are
>> there any macros involved in what you are doing?
>>
>> --
>> 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
>>
>> "Priya" <Priya[ at ]discussions.microsoft.com> wrote in message
>> news:451143A5-08E7-470E-B482-305427C3DB89[ at ]microsoft.com...
>> > Doug,
>> >
>> > Many thanks for this. I have saved the template, as you have
>> > specified.
>> > My
>> > clients require everything in office 2007 formats.
>> >
>> > Is there any way to do the same. I am new to this newsgroup and also
>> > VBA.
>> > Please help me out to solve this.
>> >
>> > Thanks,
>> > Priya.
>> >
>> > "Doug Robbins - Word MVP" wrote:
>> >
>> >> How did you change the template from .dot to .dotm? Simply by
>> >> changing
>> >> the
>> >> file name will not work. You would have to open the template using
>> >> File>Open and then use File>Save As and in the File Save As dialog,
>> >> change
>> >> the the document type to Word Macro-Enabled Template (*.dotm).
>> >>
>> >> However, are there any macros in the original template that require it
>> >> to
>> >> be
>> >> a macro-enabled template.
>> >>
>> >> A final question is why do you need this to be in Office 2007 format?
>> >> Word
>> >> 2007 can use files in earlier formats for mail merge. If it ain't
>> >> broke,
>> >> don't fix 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
>> >>
>> >> "Priya" <Priya[ at ]discussions.microsoft.com> wrote in message
>> >> news:EBD2ABD3-1CD4-4B20-AD2D-15FB68B8CB6D[ at ]microsoft.com...
>> >> > My requirement is to create the mailmerge documents in office 2007
>> >> > formats
>> >> > i.e. using .docx and .docm. I am using a template for the same. I
>> >> > have
>> >> > changed my template name from .dot to .dotm. I am saving the header
>> >> > document
>> >> > as .docx and main document as .docm
>> >> >
>> >> > when I try to reopen the mail merged main document, i am getting the
>> >> > following error "The Office Open XML File cannot be opened because
>> >> > there
>> >> > are
>> >> > problems with the contents". Please can this be sorted out. Does
>> >> > mailmerge
>> >> > work with the office 2007 formats?
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>


Home | Search | Terms | Imprint
Newsgroups Reader