A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Mail Merge using INCLUDETEXT



 
 
Thread Tools Display Modes
  #1  
Old December 17th, 2008, 12:41 PM posted to microsoft.public.word.mailmerge.fields
Xanbaby
external usenet poster
 
Posts: 22
Default Mail Merge using INCLUDETEXT

Following on from a previous post in Word Formatting (thanks to macropod for
the help), I am using a program which essentially works using the same
principles as a mail merge (enter a database, select a record, call a MS
Word template, populate keywords).

I have a source document with calculations which would be used in many
templates, and will need to be updated and maintained, so that when it is
called, any updates completed in the source document are reflected in the
target document. I believe the best way to achieve this is to use an
INCLUDETEXT, and link to a bookmark in the source document (I need to avoid
CR returns). However no matter what I've attempted, while I can insert
the full document or bookmarked section using Insert, File, if I insert
these as Insert, File, Insert as Link, it does insert the required section,
but does not update the calculations (the important bit).

Is this possible using Mail Merge? I've tried MS Word Help & Google without
much success, any assistance would be greatly appreciated.



  #2  
Old December 17th, 2008, 01:09 PM posted to microsoft.public.word.mailmerge.fields
Jack 30[_2_]
external usenet poster
 
Posts: 4
Default Mail Merge using INCLUDETEXT

I tried the Grahams link prior to the posting but got lost at about the MAPI
folder
when he said something about "I haven't tried it personally but go a folder
up at a time" then when I got to the Data folder change to merge I was
really stumped.
My 2007 and is newer, of course, and I really am fairly good at running
programs but the MAPI and items of are really kind of too much for me. I
would do better with a step by step explanation then a "philisopical or
theory explanation"
I have had friends say to me they don't know how to use the computer,
usually these friends are in an older age group, because I don't understand
how they work"
Well I don't either and don't want to learn. I just want to push the button
and have what microsoft sold be, for a steep price I might add, work as they
advertised.
Sure I can jiggle around and do small repairs and maintenance. I am also
good and working short cuts if I want to do something but don't want to add
another program.
Basically, this problem should not exist and I for one am disappointed that
there are 6 mail merge buttons one in outlook, word, publsher ect along with
auto mail merge jsut follow the wizard and it doesn't work! There is no
excuse and microsoft should be ashamed. I will try Grahams explanation again.
Thanks

"Xanbaby" wrote:

Following on from a previous post in Word Formatting (thanks to macropod for
the help), I am using a program which essentially works using the same
principles as a mail merge (enter a database, select a record, call a MS
Word template, populate keywords).

I have a source document with calculations which would be used in many
templates, and will need to be updated and maintained, so that when it is
called, any updates completed in the source document are reflected in the
target document. I believe the best way to achieve this is to use an
INCLUDETEXT, and link to a bookmark in the source document (I need to avoid
CR returns). However no matter what I've attempted, while I can insert
the full document or bookmarked section using Insert, File, if I insert
these as Insert, File, Insert as Link, it does insert the required section,
but does not update the calculations (the important bit).

Is this possible using Mail Merge? I've tried MS Word Help & Google without
much success, any assistance would be greatly appreciated.




  #3  
Old December 17th, 2008, 04:31 PM posted to microsoft.public.word.mailmerge.fields
Xanbaby
external usenet poster
 
Posts: 22
Default Mail Merge using INCLUDETEXT

Erm, thanks to Jack 30 for that, but alas, he's replied to the wrong post.
Still need help with this!

Thanks.


"Jack 30" wrote in message
...
I tried the Grahams link prior to the posting but got lost at about the
MAPI
folder
when he said something about "I haven't tried it personally but go a
folder
up at a time" then when I got to the Data folder change to merge I was
really stumped.
My 2007 and is newer, of course, and I really am fairly good at running
programs but the MAPI and items of are really kind of too much for me. I
would do better with a step by step explanation then a "philisopical or
theory explanation"
I have had friends say to me they don't know how to use the computer,
usually these friends are in an older age group, because I don't
understand
how they work"
Well I don't either and don't want to learn. I just want to push the
button
and have what microsoft sold be, for a steep price I might add, work as
they
advertised.
Sure I can jiggle around and do small repairs and maintenance. I am also
good and working short cuts if I want to do something but don't want to
add
another program.
Basically, this problem should not exist and I for one am disappointed
that
there are 6 mail merge buttons one in outlook, word, publsher ect along
with
auto mail merge jsut follow the wizard and it doesn't work! There is no
excuse and microsoft should be ashamed. I will try Grahams explanation
again.
Thanks

"Xanbaby" wrote:

Following on from a previous post in Word Formatting (thanks to macropod
for
the help), I am using a program which essentially works using the same
principles as a mail merge (enter a database, select a record, call a MS
Word template, populate keywords).

I have a source document with calculations which would be used in many
templates, and will need to be updated and maintained, so that when it is
called, any updates completed in the source document are reflected in the
target document. I believe the best way to achieve this is to use an
INCLUDETEXT, and link to a bookmark in the source document (I need to
avoid
CR returns). However no matter what I've attempted, while I can insert
the full document or bookmarked section using Insert, File, if I insert
these as Insert, File, Insert as Link, it does insert the required
section,
but does not update the calculations (the important bit).

Is this possible using Mail Merge? I've tried MS Word Help & Google
without
much success, any assistance would be greatly appreciated.






  #4  
Old December 17th, 2008, 07:35 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Mail Merge using INCLUDETEXT

If you copy something and use PasteSpecial and check the Link box, it
should then be updated either,

1. When you re-open the document if you have the setting for Update
automatic links on open checked

2. When you use Ctrl+A then press F9

3. When you use PrintPreview (if you have the Update Fields option set
in the Print section of the ToolsOptions dialog)

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

"Xanbaby" wrote in message
...
Erm, thanks to Jack 30 for that, but alas, he's replied to the wrong post.
Still need help with this!

Thanks.


"Jack 30" wrote in message
...
I tried the Grahams link prior to the posting but got lost at about the
MAPI
folder
when he said something about "I haven't tried it personally but go a
folder
up at a time" then when I got to the Data folder change to merge I was
really stumped.
My 2007 and is newer, of course, and I really am fairly good at running
programs but the MAPI and items of are really kind of too much for me. I
would do better with a step by step explanation then a "philisopical or
theory explanation"
I have had friends say to me they don't know how to use the computer,
usually these friends are in an older age group, because I don't
understand
how they work"
Well I don't either and don't want to learn. I just want to push the
button
and have what microsoft sold be, for a steep price I might add, work as
they
advertised.
Sure I can jiggle around and do small repairs and maintenance. I am also
good and working short cuts if I want to do something but don't want to
add
another program.
Basically, this problem should not exist and I for one am disappointed
that
there are 6 mail merge buttons one in outlook, word, publsher ect along
with
auto mail merge jsut follow the wizard and it doesn't work! There is no
excuse and microsoft should be ashamed. I will try Grahams explanation
again.
Thanks

"Xanbaby" wrote:

Following on from a previous post in Word Formatting (thanks to macropod
for
the help), I am using a program which essentially works using the same
principles as a mail merge (enter a database, select a record, call a MS
Word template, populate keywords).

I have a source document with calculations which would be used in many
templates, and will need to be updated and maintained, so that when it
is
called, any updates completed in the source document are reflected in
the
target document. I believe the best way to achieve this is to use an
INCLUDETEXT, and link to a bookmark in the source document (I need to
avoid
CR returns). However no matter what I've attempted, while I can
insert
the full document or bookmarked section using Insert, File, if I insert
these as Insert, File, Insert as Link, it does insert the required
section,
but does not update the calculations (the important bit).

Is this possible using Mail Merge? I've tried MS Word Help & Google
without
much success, any assistance would be greatly appreciated.








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.