still problem with mailmerge and attachment

C

Chris

Hi,

i read this article:
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

but i'm not sure i understand it well ...

i did this: ( i use windows xp sp2 and office 2003 dutch version)

1) i made a word document (mails.doc) with a table containing this:

Emails
attachment

(e-mail address removed)
c:\mailmerge\attach.txt

(e-mail address removed)
c:\mailmerge\attach.txt




2) then i made a new word-document with the vba-macro found in the link
above and put the reference to MS Outlook 11, and i started the mailmerge
procedure:

in the first step, i choosed "email".

in the third step, i browsed to the file 'mails.doc' which contains the
table; i can see the two emails and paths of the attachment.

in step four, i write the body of all emails.

in step six, i clicked on 'electronic post', then Word asks to open a file
(i presume the attachment file) and then the subject of the email.

Then i execute the macro: at that moment, i get continuously the windows
warning me " trying automatically to send emails ...". It doesn't stop. I
have to kill the process.

And finally, the emails are sent, but without attachment.



Did i do something wrong?

Thanks

Chris
 
D

Doug Robbins - Word MVP

The step six is not correct. The mail merge that is to become the body of
the document must be executed to a new document and then with that document
as the active document, you execute the macro. It will then ask you to
select the document that you had created that includes the email address and
the filenames of the attachments.

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

Chris

Thanks for replying, but this time nothing happens, except the warning
message ...

i have already the word-document containing the table.
Could you please tell me the steps to follow, because i tried a lot of
combinations and it's still confusing to me..

I start mailmerge procedure in Word.
step one: letter or email?
step two: present document or another?
step three: i have to point to the document containig the table?
step four: i write the body?
step five: ?

thanks
 
D

Doug Robbins - Word MVP

Step 5 - Insert the merge fields into the mail merge main document.

Step 6 - Execute the merge to a new document. - That new document will
contain the letter for each recipient in a separate section.

Assuming that before this you have created and executed the directory type
mail merge to a new document which you have saved and then closed, after
Step 6, with the new document created by that step as the active document,
you execute the macro which will then ask you to open the document created
by the directory type mail merge, etc.

Sounds like you need to read the article very carefully and follow the steps
in it exactly without trying to take any shortcuts.

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

Chris

thanks

Doug Robbins - Word MVP said:
Step 5 - Insert the merge fields into the mail merge main document.

Step 6 - Execute the merge to a new document. - That new document will
contain the letter for each recipient in a separate section.

Assuming that before this you have created and executed the directory type
mail merge to a new document which you have saved and then closed, after
Step 6, with the new document created by that step as the active document,
you execute the macro which will then ask you to open the document created
by the directory type mail merge, etc.

Sounds like you need to read the article very carefully and follow the
steps in it exactly without trying to take any shortcuts.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top