Merge Help - Keeping Data Current ??

[Neil]

Hi There, im trying to have a document set up, which will print my labels
for me - but, im pulling the data from my maling database.

the problems im having, is getting the new data - e.g. - when i update my
database, and open my word doc, its all the old data, no new data appears.

how would i do this (Word XP),


many thanks,

Neil

 

[Neil]

i have tried it that way - but i cant even get my data to show on the labels
sometimes, let along keep it up to date :-(


where am i going wrong......

neil

 

[Peter Jamieson]

I just wonder whether you have already performed the merge to a new document
and are looking at the output document? If so, you need to go back to the
original mail merge main document and re-merge.

i have tried it that way - but i cant even get my data to show on the labels
sometimes

Can you be more specific about what is going wrong?

 

[Neil]

i still cant get it to refresh the data on open, if i give you the databse
and file, could you assist?

Many thanks,

neil

 

[Doug Robbins - Word MVP]

Hi Neil,

What document are you opening? Is it the mailmerge main document? If you
press Alt+F9, do you see { MERGEFIELD [fieldname] } fields in it?

If the answer to this is "No", then you are not opening the mailmerge main
document, but more likely a document created by executing the merge
operation.

If the answer is "Yes", then unless you have an auto-open() macro in the
document, just opening it would not cause the merge to be executed..

You must execute the merge to produce a document that contains the then
current information from the database. If you select Toolbars from the View
menu and check the Mail Merge toolbar, on the righthand side of the toolbar
that appears are a number of buttons, each of which executes the merge to a
different destination - new document, printer, email and possibly fax. Use
the appropriate one of these buttons to execute the merge.

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

 

[Neil]

if possible, could someone tell me the code for a macro, that when the
document opens, it will create a new merged document from the databse which
is attached,

e.g. - if i update the databse before opening the document, it will add the
new data.

Thanks,

Neil

Hi Neil,

What document are you opening? Is it the mailmerge main document? If you
press Alt+F9, do you see { MERGEFIELD [fieldname] } fields in it?

If the answer to this is "No", then you are not opening the mailmerge main
document, but more likely a document created by executing the merge
operation.

If the answer is "Yes", then unless you have an auto-open() macro in the
document, just opening it would not cause the merge to be executed..

You must execute the merge to produce a document that contains the then
current information from the database. If you select Toolbars from the View
menu and check the Mail Merge toolbar, on the righthand side of the toolbar
that appears are a number of buttons, each of which executes the merge to a
different destination - new document, printer, email and possibly fax. Use
the appropriate one of these buttons to execute the merge.

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

i still cant get it to refresh the data on open, if i give you the databse
and file, could you assist?

Many thanks,

neil

 

[Doug Robbins - Word MVP]

Hi Neil,

From the Visual Basic Help file:

Set myMerge = ActiveDocument.MailMerge
If myMerge.State = wdMainAndDataSource Then MyMerge.Execute

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

if possible, could someone tell me the code for a macro, that when the
document opens, it will create a new merged document from the databse which
is attached,

e.g. - if i update the databse before opening the document, it will add the
new data.

Thanks,

Neil

Hi Neil,

What document are you opening? Is it the mailmerge main document? If you
press Alt+F9, do you see { MERGEFIELD [fieldname] } fields in it?

If the answer to this is "No", then you are not opening the mailmerge main
document, but more likely a document created by executing the merge
operation.

If the answer is "Yes", then unless you have an auto-open() macro in the
document, just opening it would not cause the merge to be executed..

You must execute the merge to produce a document that contains the then
current information from the database. If you select Toolbars from the View
menu and check the Mail Merge toolbar, on the righthand side of the toolbar
that appears are a number of buttons, each of which executes the merge

to

a
different destination - new document, printer, email and possibly fax. Use
the appropriate one of these buttons to execute the merge.

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

print

my

data,

no

 

[Neil]

sorry, i should have stated,

i've not had much experience with macro's

how would i create this, then run it when the document opens?


Thanks,

Neil

Hi Neil,

From the Visual Basic Help file:

Set myMerge = ActiveDocument.MailMerge
If myMerge.State = wdMainAndDataSource Then MyMerge.Execute

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

if possible, could someone tell me the code for a macro, that when the
document opens, it will create a new merged document from the databse which
is attached,

e.g. - if i update the databse before opening the document, it will add the
new data.

Thanks,

Neil

Hi Neil,

What document are you opening? Is it the mailmerge main document? If you
press Alt+F9, do you see { MERGEFIELD [fieldname] } fields in it?

If the answer to this is "No", then you are not opening the mailmerge main
document, but more likely a document created by executing the merge
operation.

If the answer is "Yes", then unless you have an auto-open() macro in the
document, just opening it would not cause the merge to be executed..

You must execute the merge to produce a document that contains the then
current information from the database. If you select Toolbars from

the
View

menu and check the Mail Merge toolbar, on the righthand side of the toolbar
that appears are a number of buttons, each of which executes the merge

to

a
different destination - new document, printer, email and possibly fax. Use
the appropriate one of these buttons to execute the merge.

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
i still cant get it to refresh the data on open, if i give you the databse
and file, could you assist?

Many thanks,

neil
I just wonder whether you have already performed the merge to a new
document
and are looking at the output document? If so, you need to go back to
the
original mail merge main document and re-merge.

i have tried it that way - but i cant even get my data to show

on
the

labels
sometimes

Can you be more specific about what is going wrong?

--
Peter Jamieson
MS Word MVP

i have tried it that way - but i cant even get my data to show

on
the

labels
sometimes, let along keep it up to date :-(


where am i going wrong......

neil
Re-attach the updated data file to the merge source document.
See
http://www.gmayor.dsl.pipex.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>



Neil wrote:
Hi There, im trying to have a document set up, which will

print

my
labels for me - but, im pulling the data from my maling database.

the problems im having, is getting the new data - e.g. -

when

i data,

 

[Neil]

sorry - i meant auto run it........

i now have my macro running when i run it manually


Neil

sorry, i should have stated,

i've not had much experience with macro's

how would i create this, then run it when the document opens?


Thanks,

Neil

Hi Neil,

From the Visual Basic Help file:

Set myMerge = ActiveDocument.MailMerge
If myMerge.State = wdMainAndDataSource Then MyMerge.Execute

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

if possible, could someone tell me the code for a macro, that when the
document opens, it will create a new merged document from the databse which
is attached,

e.g. - if i update the databse before opening the document, it will

add
the

new data.

Thanks,

Neil
Hi Neil,

What document are you opening? Is it the mailmerge main document?

If
you

press Alt+F9, do you see { MERGEFIELD [fieldname] } fields in it?

If the answer to this is "No", then you are not opening the

mailmerge
main

document, but more likely a document created by executing the merge
operation.

If the answer is "Yes", then unless you have an auto-open() macro in the
document, just opening it would not cause the merge to be executed..

You must execute the merge to produce a document that contains the then
current information from the database. If you select Toolbars from the
View
menu and check the Mail Merge toolbar, on the righthand side of the
toolbar
that appears are a number of buttons, each of which executes the

merge
to

a
different destination - new document, printer, email and possibly fax.
Use
the appropriate one of these buttons to execute the merge.

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
i still cant get it to refresh the data on open, if i give you the
databse
and file, could you assist?

Many thanks,

neil
I just wonder whether you have already performed the merge to a new
document
and are looking at the output document? If so, you need to go

back
to

the
original mail merge main document and re-merge.

i have tried it that way - but i cant even get my data to show on
the
labels
sometimes

Can you be more specific about what is going wrong?

--
Peter Jamieson
MS Word MVP

i have tried it that way - but i cant even get my data to show on
the
labels
sometimes, let along keep it up to date :-(


where am i going wrong......

neil
Re-attach the updated data file to the merge source document.
See
http://www.gmayor.dsl.pipex.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>



Neil wrote:
Hi There, im trying to have a document set up, which will print
my
labels for me - but, im pulling the data from my maling
database.

the problems im having, is getting the new data - e.g. -

when

i
update my database, and open my word doc, its all the old data,
no
new data appears.

how would i do this (Word XP),


many thanks,

Neil

 

[Peter Jamieson]

You can do this by calling your macro from a Sub called AutoOpen.

See the VBA pages at http://www.mvps.org/word for further info on Auto
macros.

--
Peter Jamieson
MS Word MVP

sorry - i meant auto run it........

i now have my macro running when i run it manually


Neil

sorry, i should have stated,

i've not had much experience with macro's

how would i create this, then run it when the document opens?


Thanks,

Neil

Hi Neil,

From the Visual Basic Help file:

Set myMerge = ActiveDocument.MailMerge
If myMerge.State = wdMainAndDataSource Then MyMerge.Execute

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
if possible, could someone tell me the code for a macro, that when the
document opens, it will create a new merged document from the databse
which
is attached,

e.g. - if i update the databse before opening the document, it will add
the
new data.

Thanks,

Neil
Hi Neil,

What document are you opening? Is it the mailmerge main document? If
you
press Alt+F9, do you see { MERGEFIELD [fieldname] } fields in it?

If the answer to this is "No", then you are not opening the mailmerge
main
document, but more likely a document created by executing the merge
operation.

If the answer is "Yes", then unless you have an auto-open() macro

in
the

document, just opening it would not cause the merge to be executed..

You must execute the merge to produce a document that contains the then
current information from the database. If you select Toolbars

from
the

View
menu and check the Mail Merge toolbar, on the righthand side of the
toolbar
that appears are a number of buttons, each of which executes the merge
to
a
different destination - new document, printer, email and possibly fax.
Use
the appropriate one of these buttons to execute the merge.

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
i still cant get it to refresh the data on open, if i give you the
databse
and file, could you assist?

Many thanks,

neil
I just wonder whether you have already performed the merge to

a
new

document
and are looking at the output document? If so, you need to go back
to
the
original mail merge main document and re-merge.

i have tried it that way - but i cant even get my data to

show
on

the
labels
sometimes

Can you be more specific about what is going wrong?

--
Peter Jamieson
MS Word MVP

i have tried it that way - but i cant even get my data to

show
on

the
labels
sometimes, let along keep it up to date :-(


where am i going wrong......

neil
Re-attach the updated data file to the merge source document.
See
http://www.gmayor.dsl.pipex.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>



Neil wrote:
Hi There, im trying to have a document set up, which will
print
my
labels for me - but, im pulling the data from my maling
database.

the problems im having, is getting the new data - e.g. - when
i
update my database, and open my word doc, its all the old
data,
no
new data appears.

how would i do this (Word XP),


many thanks,

Neil