View Single Post
  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Email Merge with Attachment

It was not the attachment about which I was asking the number of Sections.
It was the mail merge document that is going to be emailed and to which the
other document/file is going to be attached. That is the document that is
created by executing the merge to a new document and which is to be the
Active Document when the macro is run.

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

"LyndieBee" wrote in message
...
For my test file, it is a one-liner attachment with only one section. Do
I
need section break at the end of the text?

"Doug Robbins - Word MVP" wrote:

Have you activated the Express Click Yes utility?

What you see in the Visual Basic Editor after pressing Ctrl-Break,
doesn't
really mean anything is wrong with that section of the code.

In the letter that you are trying to email with the attachments, how many
Sections are there?

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

"LyndieBee" wrote in message
...
I'm using the directions from Doug Robbins "Mail Merge to E-mail with
Attachments" article. I've done the prep, created the directory merge
with
email addresses and document names. I've created the letter merge to a
new
document and run the macro. Every thing seems to work correctly at the
start--I get the "Enter the subject..." and the rest of the preliminary
stuff. Then it starts to do it's work and I answer Yes to "A program
is
trying to automatically send e-mail..." for the 3 addresses in my
sample
list. But at this point it seems to hang and I continue getting this
Information box for Document 4, Document 5, Document 6, etc. until I
Ctrl-Break to stop the process. When I look at the macro contents it
points
to this section:
End With
Set oItem = Nothing
ActiveDocument.Close wdDoNotSaveChanges
Counter = Counter + 1
Wend
Any ideas about what my problem is and how I can correct it? I'm so
close
and yet so far away.
Thanks,
Lyndie