I am trying to learn how to use this. How do I start a new thread? I have
a question about mail merge, but I don't even know how to start a thread in
order to ask it. Can you please tell me how to start a new thread.

My question about mail merge is: I writing a directory on names an address
with two columns per page. I want the name to be followed by the address,
but some adresses have two line to them. Therefore the names don't alsways
match up on both columns. I think I need it to add an extra blank line for
the names that have one address line. How do I do that?

"raj" wrote:

I am using Outlook 2000 SR1 and Word 2000 SR1.

I have an email message that I need to send to everyone in my
contacts folder. So I tried Mail Merge. The body of my
message contains some formatted text and also few images. I
changed my Outlook's Mail Format as HTML and MSWord as my email
editor. When I send the messages through mail merge, the
receiver's mail is in plain text. I also tried "Includepicture" field for images. Still don't work with mail merge.

But, when I send a mail individually to them, the receiver
receives the mail in HTML format.

I also checked the recipient's property "Send email using plain
text only" and it is checked OFF.

Can some one please suggest me how to mail merge the formatted contents?

Put the merge fields in the cells of a one row table with nothing else in
the main document. Then when you execute the merge to a new document you
will get the layout that you want.

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

"donna" wrote in message
...
I am trying to learn how to use this. How do I start a new thread? I
have
a question about mail merge, but I don't even know how to start a thread
in
order to ask it. Can you please tell me how to start a new thread.

My question about mail merge is: I writing a directory on names an
address
with two columns per page. I want the name to be followed by the address,
but some adresses have two line to them. Therefore the names don't
alsways
match up on both columns. I think I need it to add an extra blank line
for
the names that have one address line. How do I do that?

"raj" wrote:

I am using Outlook 2000 SR1 and Word 2000 SR1.

I have an email message that I need to send to everyone in my
contacts folder. So I tried Mail Merge. The body of my
message contains some formatted text and also few images. I
changed my Outlook's Mail Format as HTML and MSWord as my email
editor. When I send the messages through mail merge, the
receiver's mail is in plain text. I also tried "Includepicture" field for
images. Still don't work with mail merge.

But, when I send a mail individually to them, the receiver
receives the mail in HTML format.

I also checked the recipient's property "Send email using plain
text only" and it is checked OFF.

Can some one please suggest me how to mail merge the formatted contents?

Thanks Doug. I've never used a tqable before. How do I get the fields into
the table? I am getting my data from an Excel file. This is all foreign to
me so I need basic instructions.

Also, in the future, how do I start a new thread. I think I should have
done that for my question, but I didn't know how.
Donna

"Doug Robbins - Word MVP" wrote:

Put the merge fields in the cells of a one row table with nothing else in
the main document. Then when you execute the merge to a new document you
will get the layout that you want.

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

"donna" wrote in message
...
I am trying to learn how to use this. How do I start a new thread? I
have
a question about mail merge, but I don't even know how to start a thread
in
order to ask it. Can you please tell me how to start a new thread.

My question about mail merge is: I writing a directory on names an
address
with two columns per page. I want the name to be followed by the address,
but some adresses have two line to them. Therefore the names don't
alsways
match up on both columns. I think I need it to add an extra blank line
for
the names that have one address line. How do I do that?

"raj" wrote:

I am using Outlook 2000 SR1 and Word 2000 SR1.

I have an email message that I need to send to everyone in my
contacts folder. So I tried Mail Merge. The body of my
message contains some formatted text and also few images. I
changed my Outlook's Mail Format as HTML and MSWord as my email
editor. When I send the messages through mail merge, the
receiver's mail is in plain text. I also tried "Includepicture" field for
images. Still don't work with mail merge.

But, when I send a mail individually to them, the receiver
receives the mail in HTML format.

I also checked the recipient's property "Send email using plain
text only" and it is checked OFF.

Can some one please suggest me how to mail merge the formatted contents?

For some basic information on merging - see
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm Labels are
arguably the most complex merges, but all merges are essentially similar.

Doug is talking about setting the merge document type to Directory with your
merge fields in the columns of a single row table. Merging such a document
will produce a table, similar to that shown in
http://www.gmayor.com/convert_labels...mail_merge.htm

How easy it will be to create the type of directory you want will be largely
determined by the number of fields you have in your Excel file to depict the
addresses. You need a column there for each line of the address, whether or
not it has content.

If you set up your merge document as having two columns, and set the
document type to directory. Insert the fields for a single entry at the top
of the first column then merge to a new document. That document will have
all the addresses in two columns. You can now add supplementary information
to produce the document you intend.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


What fields do you have in your Excel table that you are using for a data
source?

donna wrote:
Thanks Doug. I've never used a tqable before. How do I get the
fields into the table? I am getting my data from an Excel file.
This is all foreign to me so I need basic instructions.

Also, in the future, how do I start a new thread. I think I should
have done that for my question, but I didn't know how.
Donna

"Doug Robbins - Word MVP" wrote:

Put the merge fields in the cells of a one row table with nothing
else in the main document. Then when you execute the merge to a new
document you will get the layout that you want.

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

"donna" wrote in message
...
I am trying to learn how to use this. How do I start a new
thread? I have
a question about mail merge, but I don't even know how to start a
thread in
order to ask it. Can you please tell me how to start a new thread.

My question about mail merge is: I writing a directory on names an
address
with two columns per page. I want the name to be followed by the
address, but some adresses have two line to them. Therefore the
names don't alsways
match up on both columns. I think I need it to add an extra blank
line for
the names that have one address line. How do I do that?

"raj" wrote:

I am using Outlook 2000 SR1 and Word 2000 SR1.

I have an email message that I need to send to everyone in my
contacts folder. So I tried Mail Merge. The body of my
message contains some formatted text and also few images. I
changed my Outlook's Mail Format as HTML and MSWord as my email
editor. When I send the messages through mail merge, the
receiver's mail is in plain text. I also tried "Includepicture"
field for images. Still don't work with mail merge.

But, when I send a mail individually to them, the receiver
receives the mail in HTML format.

I also checked the recipient's property "Send email using plain
text only" and it is checked OFF.

Can some one please suggest me how to mail merge the formatted
contents?

I tried comvertingthe excel file to a table but I couldn't do it. I had no
idea what the instructions were talking about
inwww.gmayor.com/convert_labels_into_mail_merge.htm.

Can anyone else help?

"Graham Mayor" wrote:

For some basic information on merging - see
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm Labels are
arguably the most complex merges, but all merges are essentially similar.

Doug is talking about setting the merge document type to Directory with your
merge fields in the columns of a single row table. Merging such a document
will produce a table, similar to that shown in
http://www.gmayor.com/convert_labels...mail_merge.htm

How easy it will be to create the type of directory you want will be largely
determined by the number of fields you have in your Excel file to depict the
addresses. You need a column there for each line of the address, whether or
not it has content.

If you set up your merge document as having two columns, and set the
document type to directory. Insert the fields for a single entry at the top
of the first column then merge to a new document. That document will have
all the addresses in two columns. You can now add supplementary information
to produce the document you intend.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


What fields do you have in your Excel table that you are using for a data
source?

donna wrote:
Thanks Doug. I've never used a tqable before. How do I get the
fields into the table? I am getting my data from an Excel file.
This is all foreign to me so I need basic instructions.

Also, in the future, how do I start a new thread. I think I should
have done that for my question, but I didn't know how.
Donna

"Doug Robbins - Word MVP" wrote:

Put the merge fields in the cells of a one row table with nothing
else in the main document. Then when you execute the merge to a new
document you will get the layout that you want.

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

"donna" wrote in message
...
I am trying to learn how to use this. How do I start a new
thread? I have
a question about mail merge, but I don't even know how to start a
thread in
order to ask it. Can you please tell me how to start a new thread.

My question about mail merge is: I writing a directory on names an
address
with two columns per page. I want the name to be followed by the
address, but some adresses have two line to them. Therefore the
names don't alsways
match up on both columns. I think I need it to add an extra blank
line for
the names that have one address line. How do I do that?

"raj" wrote:

I am using Outlook 2000 SR1 and Word 2000 SR1.

I have an email message that I need to send to everyone in my
contacts folder. So I tried Mail Merge. The body of my
message contains some formatted text and also few images. I
changed my Outlook's Mail Format as HTML and MSWord as my email
editor. When I send the messages through mail merge, the
receiver's mail is in plain text. I also tried "Includepicture"
field for images. Still don't work with mail merge.

But, when I send a mail individually to them, the receiver
receives the mail in HTML format.

I also checked the recipient's property "Send email using plain
text only" and it is checked OFF.

Can some one please suggest me how to mail merge the formatted
contents?

The Excel file already is a table. The link was merely to show what the
format of the table should look like in order fopr it work as a data source.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


donna wrote:
I tried comvertingthe excel file to a table but I couldn't do it. I
had no idea what the instructions were talking about
inwww.gmayor.com/convert_labels_into_mail_merge.htm.

Can anyone else help?

"Graham Mayor" wrote:

For some basic information on merging - see
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm Labels are
arguably the most complex merges, but all merges are essentially
similar.

Doug is talking about setting the merge document type to Directory
with your merge fields in the columns of a single row table. Merging
such a document will produce a table, similar to that shown in
http://www.gmayor.com/convert_labels...mail_merge.htm

How easy it will be to create the type of directory you want will be
largely determined by the number of fields you have in your Excel
file to depict the addresses. You need a column there for each line
of the address, whether or not it has content.

If you set up your merge document as having two columns, and set the
document type to directory. Insert the fields for a single entry at
the top of the first column then merge to a new document. That
document will have all the addresses in two columns. You can now add
supplementary information to produce the document you intend.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


What fields do you have in your Excel table that you are using for a
data source?

donna wrote:
Thanks Doug. I've never used a tqable before. How do I get the
fields into the table? I am getting my data from an Excel file.
This is all foreign to me so I need basic instructions.

Also, in the future, how do I start a new thread. I think I should
have done that for my question, but I didn't know how.
Donna

"Doug Robbins - Word MVP" wrote:

Put the merge fields in the cells of a one row table with nothing
else in the main document. Then when you execute the merge to a
new document you will get the layout that you want.

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

"donna" wrote in message
...
I am trying to learn how to use this. How do I start a new
thread? I have
a question about mail merge, but I don't even know how to start a
thread in
order to ask it. Can you please tell me how to start a new
thread.

My question about mail merge is: I writing a directory on names
an address
with two columns per page. I want the name to be followed by the
address, but some adresses have two line to them. Therefore the
names don't alsways
match up on both columns. I think I need it to add an extra blank
line for
the names that have one address line. How do I do that?

"raj" wrote:

I am using Outlook 2000 SR1 and Word 2000 SR1.

I have an email message that I need to send to everyone in my
contacts folder. So I tried Mail Merge. The body of my
message contains some formatted text and also few images. I
changed my Outlook's Mail Format as HTML and MSWord as my email
editor. When I send the messages through mail merge, the
receiver's mail is in plain text. I also tried "Includepicture"
field for images. Still don't work with mail merge.

But, when I send a mail individually to them, the receiver
receives the mail in HTML format.

I also checked the recipient's property "Send email using plain
text only" and it is checked OFF.

Can some one please suggest me how to mail merge the formatted
contents?

Your response solved one part of my merge problem. I am converting a WP
merge document to Word. The WP document contained a caption for the report
as well as a header row on the table. However, if I include the caption and
header rows in the Word document before merging, it includes them for each
record. Is it possible to set these up in the merge document before it is
merged or do they need to be inserted after completing the merge? Thanks for
your help.

"Doug Robbins - Word MVP" wrote:

Put the merge fields in the cells of a one row table with nothing else in
the main document. Then when you execute the merge to a new document you
will get the layout that you want.

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

"donna" wrote in message
...
I am trying to learn how to use this. How do I start a new thread? I
have
a question about mail merge, but I don't even know how to start a thread
in
order to ask it. Can you please tell me how to start a new thread.

My question about mail merge is: I writing a directory on names an
address
with two columns per page. I want the name to be followed by the address,
but some adresses have two line to them. Therefore the names don't
alsways
match up on both columns. I think I need it to add an extra blank line
for
the names that have one address line. How do I do that?

"raj" wrote:

I am using Outlook 2000 SR1 and Word 2000 SR1.

I have an email message that I need to send to everyone in my
contacts folder. So I tried Mail Merge. The body of my
message contains some formatted text and also few images. I
changed my Outlook's Mail Format as HTML and MSWord as my email
editor. When I send the messages through mail merge, the
receiver's mail is in plain text. I also tried "Includepicture" field for
images. Still don't work with mail merge.

But, when I send a mail individually to them, the receiver
receives the mail in HTML format.

I also checked the recipient's property "Send email using plain
text only" and it is checked OFF.

Can some one please suggest me how to mail merge the formatted contents?

See response to your later post.

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

"sstires" wrote in message
...
Your response solved one part of my merge problem. I am converting a WP
merge document to Word. The WP document contained a caption for the
report
as well as a header row on the table. However, if I include the caption
and
header rows in the Word document before merging, it includes them for each
record. Is it possible to set these up in the merge document before it is
merged or do they need to be inserted after completing the merge? Thanks
for
your help.

"Doug Robbins - Word MVP" wrote:

Put the merge fields in the cells of a one row table with nothing else in
the main document. Then when you execute the merge to a new document you
will get the layout that you want.

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

"donna" wrote in message
...
I am trying to learn how to use this. How do I start a new thread? I
have
a question about mail merge, but I don't even know how to start a
thread
in
order to ask it. Can you please tell me how to start a new thread.

My question about mail merge is: I writing a directory on names an
address
with two columns per page. I want the name to be followed by the
address,
but some adresses have two line to them. Therefore the names don't
alsways
match up on both columns. I think I need it to add an extra blank line
for
the names that have one address line. How do I do that?

"raj" wrote:

I am using Outlook 2000 SR1 and Word 2000 SR1.

I have an email message that I need to send to everyone in my
contacts folder. So I tried Mail Merge. The body of my
message contains some formatted text and also few images. I
changed my Outlook's Mail Format as HTML and MSWord as my email
editor. When I send the messages through mail merge, the
receiver's mail is in plain text. I also tried "Includepicture" field
for
images. Still don't work with mail merge.

But, when I send a mail individually to them, the receiver
receives the mail in HTML format.

I also checked the recipient's property "Send email using plain
text only" and it is checked OFF.

Can some one please suggest me how to mail merge the formatted
contents?

[paulb]

Doug

You appear to be an expert and I need help! I have a column in excel with
numbers and they are 12 digits long. Excel automatically formats these in
scientific format. I have changed these formats into text, number accounting,
custom, but when i mail merge the scientific format keeps appearing. I have
saved the excel file each time I have changed. How can I remove the
scientific format when merged into the word doc.

"Doug Robbins - Word MVP" wrote:

Put the merge fields in the cells of a one row table with nothing else in
the main document. Then when you execute the merge to a new document you
will get the layout that you want.

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

"donna" wrote in message
...
I am trying to learn how to use this. How do I start a new thread? I
have
a question about mail merge, but I don't even know how to start a thread
in
order to ask it. Can you please tell me how to start a new thread.

My question about mail merge is: I writing a directory on names an
address
with two columns per page. I want the name to be followed by the address,
but some adresses have two line to them. Therefore the names don't
alsways
match up on both columns. I think I need it to add an extra blank line
for
the names that have one address line. How do I do that?

"raj" wrote:

I am using Outlook 2000 SR1 and Word 2000 SR1.

I have an email message that I need to send to everyone in my
contacts folder. So I tried Mail Merge. The body of my
message contains some formatted text and also few images. I
changed my Outlook's Mail Format as HTML and MSWord as my email
editor. When I send the messages through mail merge, the
receiver's mail is in plain text. I also tried "Includepicture" field for
images. Still don't work with mail merge.

But, when I send a mail individually to them, the receiver
receives the mail in HTML format.

I also checked the recipient's property "Send email using plain
text only" and it is checked OFF.

Can some one please suggest me how to mail merge the formatted contents?

[Doug Robbins - Word MVP]

A couple of things to try:

1. From the Tools menu in Word, select Options and then on the General
tab, check the box against "Confirm conversions at open". Then, when you
attach the data source to the mail merge main document, select the DDE
option in the dialog box that will appear.

2. See "Formatting Word fields with switches" on fellow MVP Graham
Mayor's website at:

http://www.gmayor.com/formatting_word_fields.htm

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

"paulb" wrote in message
news
Doug

You appear to be an expert and I need help! I have a column in excel with
numbers and they are 12 digits long. Excel automatically formats these in
scientific format. I have changed these formats into text, number
accounting,
custom, but when i mail merge the scientific format keeps appearing. I
have
saved the excel file each time I have changed. How can I remove the
scientific format when merged into the word doc.

"Doug Robbins - Word MVP" wrote:

Put the merge fields in the cells of a one row table with nothing else in
the main document. Then when you execute the merge to a new document you
will get the layout that you want.

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

"donna" wrote in message
...
I am trying to learn how to use this. How do I start a new thread? I
have
a question about mail merge, but I don't even know how to start a
thread
in
order to ask it. Can you please tell me how to start a new thread.

My question about mail merge is: I writing a directory on names an
address
with two columns per page. I want the name to be followed by the
address,
but some adresses have two line to them. Therefore the names don't
alsways
match up on both columns. I think I need it to add an extra blank line
for
the names that have one address line. How do I do that?

"raj" wrote:

I am using Outlook 2000 SR1 and Word 2000 SR1.

I have an email message that I need to send to everyone in my
contacts folder. So I tried Mail Merge. The body of my
message contains some formatted text and also few images. I
changed my Outlook's Mail Format as HTML and MSWord as my email
editor. When I send the messages through mail merge, the
receiver's mail is in plain text. I also tried "Includepicture" field
for
images. Still don't work with mail merge.

But, when I send a mail individually to them, the receiver
receives the mail in HTML format.

I also checked the recipient's property "Send email using plain
text only" and it is checked OFF.

Can some one please suggest me how to mail merge the formatted
contents?