Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Mail Merge to email

4 views
Skip to first unread message

Kenneth Taylor

unread,
Oct 31, 2009, 7:40:38 AM10/31/09
to
Can anyone explain if there is a way to mail merge to email and avoid the
indent on first line of each paragraph?

Ken

John McGhie

unread,
Oct 31, 2009, 7:28:15 PM10/31/09
to
There is nothing about "Mail Merge" that adds any indents :-)

If you format your Main Document to not have any indents, the result won't
have any either. What Style are you using for the paragraph?

Are you sure you are not seeing a blank field appearing that should be
nested into an IF statement so it is suppressed if it has no content?

Cheers


On 31/10/09 10:40 PM, in article C711D2B6.2FF29%k.ta...@mdx.ac.uk, "Kenneth
Taylor" <k.ta...@mdx.ac.uk> wrote:


--

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:jo...@mcghie.name


CyberTaz

unread,
Nov 1, 2009, 8:07:28 AM11/1/09
to
As John indicated, Word's mail merge does not arbitrarily impose indentation
of its own accord. In order to help determine why it's happening you'll need
to supply a good deal more detail about the document as well as the record
source that's supplying the data along with a description of the data
itself. It would also be helpful to know what version of Word you're using,
what OS version (exact update level of both).

Regards |:>)
Bob Jones
[MVP] Office:Mac

On 10/31/09 7:40 AM, in article C711D2B6.2FF29%k.ta...@mdx.ac.uk, "Kenneth

Michel Bintener

unread,
Nov 1, 2009, 10:16:49 AM11/1/09
to
My guess is that Kenneth (the OP) talks about two different issues which he
wants to solve. Firstly, he wants to find out how to perform a mail merge to
email, and secondly, he also seems to have changed his paragraph style by
accident so that it is indented. We'll have to wait for Kenneth to post back
so we can give him the appropriate answers.


On 01/11/09 14:07, in article C712F240.55CC3%onlygen...@com.cast.net,
"CyberTaz" <onlygen...@com.cast.net> wrote:

--
Michel Bintener
Microsoft MVP - Macintosh

*** Please always reply to the newsgroup. ***

Kenneth Taylor

unread,
Nov 6, 2009, 1:31:36 PM11/6/09
to
On 31/10/2009 23:28, in article C713133F.3852%jo...@mcghie.name, "John
McGhie" <jo...@mcghie.name> wrote:

> There is nothing about "Mail Merge" that adds any indents :-)
>
> If you format your Main Document to not have any indents, the result won't
> have any either. What Style are you using for the paragraph?
>
> Are you sure you are not seeing a blank field appearing that should be
> nested into an IF statement so it is suppressed if it has no content?

Hello John,

Plain text. The main document has no indents but the result does. I can send
you image files if it helps. The paragraph style is 'normal' with no indents
or tabs. There are no blank fields.
--
Ken


Kenneth Taylor

unread,
Nov 6, 2009, 1:45:51 PM11/6/09
to
On 01/11/2009 15:16, in article C71364F1.82DF%mbin...@NOmvpsSPAM.org,
"Michel Bintener" <mbin...@NOmvpsSPAM.org> wrote:

> My guess is that Kenneth (the OP) talks about two different issues which he
> wants to solve. Firstly, he wants to find out how to perform a mail merge to
> email, and secondly, he also seems to have changed his paragraph style by
> accident so that it is indented. We'll have to wait for Kenneth to post back
> so we can give him the appropriate answers.

Hello Michael,

Microsoft Entourage.app: 12.2.0
Microsoft Excel.app: 12.2.0
Microsoft Word.app: 12.2.0
Mac OS X 10.6.1 (10B504)

I can merge to email fine. But ...

I have a Plain Text MS Word 2008 .doc file merging with a MS Excel 2008 .xls
file. At the start of paragraphs of the mail merged email I have an indent
when I view in Entourage 2008.

I have no styles in the MS Word document or tabs. I have no extra space in
the Excel spreadsheet. Where might I look to solve this glitch?
--
Ken


CyberTaz

unread,
Nov 7, 2009, 8:08:28 AM11/7/09
to
Hi Kenneth;


On 11/6/09 1:45 PM, in article C71A1F5F.305E6%k.ta...@mdx.ac.uk, "Kenneth
Taylor" <k.ta...@mdx.ac.uk> wrote:

Just to confirm that you aren't imagining things :-) I am able to reproduce
what you're reporting. Just for clarification, though, the term "indent" --
although certainly not inappropriate -- may be what was throwing us off a
little. It's more like a space which is a bit narrower than a regular
space... I think most of us envisioned something more like a true indent of
something like a quarter to a half inch. However, for the following reasons
I don't believe it's Word that's doing it...

The space occurs only if I merge to email as Text rather than as HTML. Also,
if I send the same document using File> Send To> Mail Recipient (as HTML)
the space does not occur. Additionally, if I copy from the email message &
paste into a new Word document the whitespace is retained but there is no
non-printing character in that spot. Even if I use Edit> Paste Special>
Unformatted Text the narrow space comes in with no non-printing character
displayed at the start of the first line. That suggests that Word doesn't
even know what it is but observes it anyway.

And -- as you noted -- there is no indication in Word's Ruler or Format>
Paragraph dialog that the First Line Indent is anything but 0". Another
indicator is that if I open the resulting message in Entourage & switch to
HTML the partial space goes away, switching back to Text it reappears, so
I'm thinking it might have to do with the text encoding in Entourage.

I regret that I don't have a solution for you other than to merge as HTML,
but I'd suggest you use Help> Send Feedback in Entourage to report your
findings. I'll also submit a report from my end. I'll reply here when I get
a response, but that may take a while. In the meantime you might ask in the
Entourage newsgroup where more people might be familiar with the issue.

Kenneth Taylor

unread,
Nov 8, 2009, 7:15:25 AM11/8/09
to
On 07/11/2009 13:08, in article C71ADB7C.56004%onlygen...@com.cast.net,
"CyberTaz" <onlygen...@com.cast.net> wrote:

> Just to confirm that you aren't imagining things :-) I am able to reproduce
> what you're reporting. Just for clarification, though, the term "indent" --
> although certainly not inappropriate -- may be what was throwing us off a
> little. It's more like a space which is a bit narrower than a regular
> space... I think most of us envisioned something more like a true indent of
> something like a quarter to a half inch. However, for the following reasons
> I don't believe it's Word that's doing it...

Thanks Bob,

That is exactly what I found! I am glad it was not just me ;-) I will report
it. Thanks for the confirmation.
--
Ken


0 new messages