Reply
 
Thread Tools Display Modes
  #1   Report Post  
Chris Swales
 
Posts: n/a
Default how do i suppress the header record in mailmerge

In Word (MS Office 2003) mailmerge creates a document for the header record
which describes what fields are contained in each data record. I only want to
create documents for each data record - how do I do this?
  #2   Report Post  
Charles Kenyon
 
Posts: n/a
Default how do i suppress the header record in mailmerge

Create a document with a table. The first row of your table contains your
field names. The rest of the rows contain your data.
http://word.mvps.org/FAQs/MailMerge/...DataSource.htm
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Chris Swales" Chris wrote in message
...
In Word (MS Office 2003) mailmerge creates a document for the header
record
which describes what fields are contained in each data record. I only want
to
create documents for each data record - how do I do this?



  #3   Report Post  
Adriana Malamud
 
Posts: n/a
Default how do i suppress the header record in mailmerge

I need to do the opposite, this means to keep the header record because my
data source is a .txt file without headers. I used to do that with other
office versions, but can´t with office 2003. Any help? (I can´t find where to
select the header record file.) Thanks.
--
Adriana


"Charles Kenyon" escribió:

Create a document with a table. The first row of your table contains your
field names. The rest of the rows contain your data.
http://word.mvps.org/FAQs/MailMerge/...DataSource.htm
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Chris Swales" Chris wrote in message
...
In Word (MS Office 2003) mailmerge creates a document for the header
record
which describes what fields are contained in each data record. I only want
to
create documents for each data record - how do I do this?




  #4   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default how do i suppress the header record in mailmerge

Select Tools Customize Commands (tab)
Select "All Commands" under Categories (on the left)
Scroll down the list on the right to find "MAilMergeHelper"
Click and drag it to a toolbar.
Close the Dialog.

Click on your new button to use the old mail merge.

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

"Adriana Malamud" wrote in
message ...
I need to do the opposite, this means to keep the header record because my
data source is a .txt file without headers. I used to do that with other
office versions, but can´t with office 2003. Any help? (I can´t find where
to
select the header record file.) Thanks.
--
Adriana


"Charles Kenyon" escribió:

Create a document with a table. The first row of your table contains your
field names. The rest of the rows contain your data.
http://word.mvps.org/FAQs/MailMerge/...DataSource.htm
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Chris Swales" Chris wrote in message
...
In Word (MS Office 2003) mailmerge creates a document for the header
record
which describes what fields are contained in each data record. I only
want
to
create documents for each data record - how do I do this?






  #5   Report Post  
Adriana Malamud
 
Posts: n/a
Default how do i suppress the header record in mailmerge

Sorry, I´ve already tried this (You 've suggested the same to someone else),
but the same assistant appeared. Any other suggestion?
Thanks anyway.
--
Adriana


"Doug Robbins - Word MVP" wrote:

Select Tools Customize Commands (tab)
Select "All Commands" under Categories (on the left)
Scroll down the list on the right to find "MAilMergeHelper"
Click and drag it to a toolbar.
Close the Dialog.

Click on your new button to use the old mail merge.

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

"Adriana Malamud" wrote in
message ...
I need to do the opposite, this means to keep the header record because my
data source is a .txt file without headers. I used to do that with other
office versions, but can´t with office 2003. Any help? (I can´t find where
to
select the header record file.) Thanks.
--
Adriana


"Charles Kenyon" escribió:

Create a document with a table. The first row of your table contains your
field names. The rest of the rows contain your data.
http://word.mvps.org/FAQs/MailMerge/...DataSource.htm
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Chris Swales" Chris wrote in message
...
In Word (MS Office 2003) mailmerge creates a document for the header
record
which describes what fields are contained in each data record. I only
want
to
create documents for each data record - how do I do this?








  #6   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default how do i suppress the header record in mailmerge

If by the same assistant you mean something OTHER than the one with the
title Mail Merge Helper and containing the big 1, 2 and 3 all on one dialog,
then you did not get hold of the right command when using ToolsCustomize.

If you get the right Mail Merge Helper (the one with the 1, 2 and 3) then
under 2 there is a Header Options item under the Get Data pulldown.

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

"Adriana Malamud" wrote in
message ...
Sorry, I´ve already tried this (You 've suggested the same to someone
else),
but the same assistant appeared. Any other suggestion?
Thanks anyway.
--
Adriana


"Doug Robbins - Word MVP" wrote:

Select Tools Customize Commands (tab)
Select "All Commands" under Categories (on the left)
Scroll down the list on the right to find "MAilMergeHelper"
Click and drag it to a toolbar.
Close the Dialog.

Click on your new button to use the old mail merge.

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

"Adriana Malamud" wrote in
message ...
I need to do the opposite, this means to keep the header record because
my
data source is a .txt file without headers. I used to do that with
other
office versions, but can´t with office 2003. Any help? (I can´t find
where
to
select the header record file.) Thanks.
--
Adriana


"Charles Kenyon" escribió:

Create a document with a table. The first row of your table contains
your
field names. The rest of the rows contain your data.
http://word.mvps.org/FAQs/MailMerge/...DataSource.htm
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Chris Swales" Chris wrote in
message
...
In Word (MS Office 2003) mailmerge creates a document for the header
record
which describes what fields are contained in each data record. I
only
want
to
create documents for each data record - how do I do this?








  #7   Report Post  
Adriana Malamud
 
Posts: n/a
Default how do i suppress the header record in mailmerge

I have a Spanish version of Word, but no one in the Spanish newsgroup could
help me, that's why I'm translating the commands, but the Mail Merge Helper
was the only possibility to select (Translating Helper as assistant), but
what appears is the same windows as usual, so surely I'm not finding the
right option, but couldn't find any other.
If I get the 1,2,3 all on one dialog, that would be perfect!! Anyway, I´ll
keep trying.
Thanks for all your help.
--
Adriana


"Doug Robbins - Word MVP" escribió:

If by the same assistant you mean something OTHER than the one with the
title Mail Merge Helper and containing the big 1, 2 and 3 all on one dialog,
then you did not get hold of the right command when using ToolsCustomize.

If you get the right Mail Merge Helper (the one with the 1, 2 and 3) then
under 2 there is a Header Options item under the Get Data pulldown.

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

"Adriana Malamud" wrote in
message ...
Sorry, I´ve already tried this (You 've suggested the same to someone
else),
but the same assistant appeared. Any other suggestion?
Thanks anyway.
--
Adriana


"Doug Robbins - Word MVP" wrote:

Select Tools Customize Commands (tab)
Select "All Commands" under Categories (on the left)
Scroll down the list on the right to find "MAilMergeHelper"
Click and drag it to a toolbar.
Close the Dialog.

Click on your new button to use the old mail merge.

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

"Adriana Malamud" wrote in
message ...
I need to do the opposite, this means to keep the header record because
my
data source is a .txt file without headers. I used to do that with
other
office versions, but can´t with office 2003. Any help? (I can´t find
where
to
select the header record file.) Thanks.
--
Adriana


"Charles Kenyon" escribió:

Create a document with a table. The first row of your table contains
your
field names. The rest of the rows contain your data.
http://word.mvps.org/FAQs/MailMerge/...DataSource.htm
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Chris Swales" Chris wrote in
message
...
In Word (MS Office 2003) mailmerge creates a document for the header
record
which describes what fields are contained in each data record. I
only
want
to
create documents for each data record - how do I do this?









  #8   Report Post  
Adriana Malamud
 
Posts: n/a
Default how do i suppress the header record in mailmerge

I've found it, thanks!
--
Adriana


"Doug Robbins - Word MVP" escribió:

If by the same assistant you mean something OTHER than the one with the
title Mail Merge Helper and containing the big 1, 2 and 3 all on one dialog,
then you did not get hold of the right command when using ToolsCustomize.

If you get the right Mail Merge Helper (the one with the 1, 2 and 3) then
under 2 there is a Header Options item under the Get Data pulldown.

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

"Adriana Malamud" wrote in
message ...
Sorry, I´ve already tried this (You 've suggested the same to someone
else),
but the same assistant appeared. Any other suggestion?
Thanks anyway.
--
Adriana


"Doug Robbins - Word MVP" wrote:

Select Tools Customize Commands (tab)
Select "All Commands" under Categories (on the left)
Scroll down the list on the right to find "MAilMergeHelper"
Click and drag it to a toolbar.
Close the Dialog.

Click on your new button to use the old mail merge.

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

"Adriana Malamud" wrote in
message ...
I need to do the opposite, this means to keep the header record because
my
data source is a .txt file without headers. I used to do that with
other
office versions, but can´t with office 2003. Any help? (I can´t find
where
to
select the header record file.) Thanks.
--
Adriana


"Charles Kenyon" escribió:

Create a document with a table. The first row of your table contains
your
field names. The rest of the rows contain your data.
http://word.mvps.org/FAQs/MailMerge/...DataSource.htm
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Chris Swales" Chris wrote in
message
...
In Word (MS Office 2003) mailmerge creates a document for the header
record
which describes what fields are contained in each data record. I
only
want
to
create documents for each data record - how do I do this?









  #9   Report Post  
panettone
 
Posts: n/a
Default how do i suppress the header record in mailmerge

I have a related problem. I also have an Excel data file with no headers. I
added the Mail Merge Helper and now have mail/merge set up separate files for
data and header but Word is still treating the first record of the Excel data
file as the header. Any suggestions?

Thanks


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to suppress Select Table box in Excel-Word mailmerge Denise Mailmerge 4 June 21st 05 01:08 PM
default Header Record delimiter in mail merge tricia Mailmerge 1 June 15th 05 11:14 AM
How do I stop a field from repeating in next record in mailmerge.. sandyc Mailmerge 1 April 11th 05 06:36 PM
Copying a letter header into a mailmerge template dixie Mailmerge 4 December 20th 04 08:17 AM
Mailmerge starts at wrong record Franc v/d Westelaken Mailmerge 1 December 1st 04 10:59 AM


All times are GMT +1. The time now is 03:19 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"