[Doug Robbins - Word MVP]

I recently had that article updated and in doing so, an error crept into the
code of the macro.

The line of code

For j = 1 To Source.Sections.Count

should be

For j = 1 To Source.Sections.Count - 1


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

"Tammy" wrote in message
...
Hi Peter,

I knew it was probably a guessing game at this point. Thanks for giving me
some places to look.

My table is complete, with no extra characters or empty cells. The merged
document has the correct number of letters (four, in this example) after
merging to individual letters. However, there are a total of five
sections,
instead of four. Word has automatically added an additional return at the
end
of the last letter, and the extra return appears in section five. Word has
placed the extra return after a "continuous" section break in the last
letter. (All the other letters are separated with a "next page" section
break.)

I can't delete the extra return.

After noticing that, I returned to the merged emails from yesterday and
realized this did happen then, too. The last person received the correct
email message and attachment, plus an additional email with just the
attachment.

Do you think this is a question I should post to the Word group? I'm not
so
sure it has anything to do with Outlook, or the macro to run the email
with
attachment.

I really do appreciate the time you've taken with all of this. I also
checked both of your responses as "helpful" but haven't seen the green
check
mark yet. Thanks, again!

"Peter Jamieson" wrote:

I expect I'm guessing more than Doug would be at this point, but...
a. you should be able to look at the table that you create when you do
your
catalog/directory merge.
- how many rows does it have?
- does the last row have non-blank values in both column 1 and column
2?
b. you should also be able to save the document produced by the second
mailmerge. If you click right at the end of the document
- how many sections does it have (you should be able to see int he Word
status bar)

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Tammy" wrote in message
...
Hi Peter,

Yesterday I had this working without a hitch, but today I am running
into
problems.

I have a data source that matches my directory exactly - same amount of
records and they all have an email addresses (same people in the source
and
directory). When I run the macro, the email gets sent to everyone, but
it
also keeps sending just the attachment to the last person in the
directory.
So, that person receives the correct email with the message and
attachment,
plus another email with just the attachment (but, no message). Any idea
of
why that would be happening?

I was having a problem earlier of the email going out with the
attachment,
but the "to" names did not match up to their respective "Dear *name*"
in
the
message. That is not happening anymore, and to tell you the truth, I've
run
so many tests that I don't know how I fixed it. (If any of that made
sense,
and you know why the source would not match up the names of the people
correctly, please please please let me know. That one had me baffled.)

Thanks for any suggestions on why the extra email would be going out
with
just the attachment to one of the recipients. If I should post this
question
to the Word group, please let me know.

Thanks, again! I thought I was done bugging you!

"Peter Jamieson" wrote:

I **assumed** that is where the
macro had to be created.

That is the correct assumption in this case.

But I wonder if you have looked down the whole list in the Word VBE's
Tools-References option? There can be hundreds of objects in the
list -
e.g. on my system, that particular entry is about the 450th in the
list.

It would be checked by defaul tin Outlook itself, but it would not be
checked (and therefore near the top of the list ) by default in Word.


--
Peter Jamieson
http://tips.pjmsn.me.uk

"Tammy" wrote in message
...
Hi Peter,

Thanks so much for taking the time to answer my post.

I checked two places for the reference - in Outlook, "Microsoft
Outlook
12.0
Object Library" is checked. In Word, where the macro is run from,
there
is
no
option for "Microsoft Outlook 12.0 Object Library." There is a check
next
to
"Microsoft Office 12.0 Object Library" - this is also checked in OL.
Since
an
email merge from OL takes you to Word anyway, I **assumed** that is
where
the
macro had to be created.

Any other suggestions ? I copied and pasted the VB code directly
into
the
VB
window, but the article didn't indicate if something had to be
modifed.
Thanks, again!

"Peter Jamieson" wrote:

I'm not Doug, but you probably need to use the VB Editor's
Tools-References
option to locate "Microsoft Outlook nn.0 Library" and check it
(where
nn
depends on the version of Outlook you are using).

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Tammy" wrote in message
...
Hi Doug,

I am trying to work through sending an email merge which includes
an
attachment - thanks to the very helpful articles you've provided.
However,
when I get to the part where I run the macro, I end up with a
dialog
box
that
says "Compile error: User-defined type not defined."

It then takes me to the VB window and highlights "Sub
emailmergewithattachments()" - if I click the continue button, it
highlights
the Dim
"oOutlookApp As Outlook.Application"
line.

I apologize that I am unfamiliar with VB - can you tell me what
the
message
means, and how to fix it? If I can get this email merge with an
attachment
to
work, there will be many happy people at my office.

Really appreciate any suggestions! Thank you!

"Doug Robbins - Word MVP" wrote:

Sorry, yes it is. I guess I was half awake when I read "I don't
work
with
VB" as "It doesn't work with VB"

However, all of the VB work has been done for you. To make use
of
it,
see
the article "What do I do with macros sent to me by other
newsgroup
readers
to help me out?" at:

http://www.word.mvps.org/FAQs/Macros...eateAMacro.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

"Mary Ann" wrote in message
...
Is not the macro written in visual basic?

"Doug Robbins - Word MVP" wrote:

I am not sure what you mean by VB.

However, I can assure you that if you follow the instructions
precisely
(to
the letter), it will work.

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

"Mary Ann" wrote in
message
...
Thanks Doug - I don't work with VB so I guess for me the
answer
is
that
I
would have to insert them to each individual email.

"Doug Robbins - Word MVP" wrote:

See the article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/...ttachments.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

"Mary Ann" wrote in
message
...
Is it possible to attach a file when doing an email
merge?