Problems with Mail merge with attachment

E

Emily

Hi,

I am trying to send individual emails with individual attachments. I have
followed the steps outlined in the article "Mail Merge to E-mail with
Attachments" and am having a little trouble.

I have created the directory, written the email I want to send, connected to
data source (same one that I used for the directory) and copied the Macro.
However, I when I run the macro I get the message "Compile error: statement
invalid outside Type block" and the line of code that reads " Maillist As
Document, TempDoc As Document" is highlighted. Should I have the directory
open when I start the merge? Do I run the macro or just try to send the
email merge? I am very confused and have not worked much with Macros or VBA
Editor. Also, it says in the article that when I run the Macro I will be
asked to open the directory but that has not happened. I'm sure I am doing
something wrong, but I don't know what.

Any assistance you can offer would be greatly appreciated.
 
P

Peter Jamieson

It sounds to me as if you might have copied the VBA macro so that you ended
up with

Sub emailmergewithattachments()
Dim Source As Document
Maillist As Document, TempDoc As Document

(etc.)

when you should have

Sub emailmergewithattachments()
Dim Source As Document, Maillist As Document, TempDoc As Document

(etc.)

Sometimes when you copy VBA code from an example, the lines can be split and
if you try to "fix" them and get it wrong you may end up with various sorts
of error.

In this case for example you would probably have had to remove a comma at
the end of

Dim Source As Document

to get this error.

Although I copied this code without problems, I suggest that once you have
copied it, you check what you have in VBA visually against the code in
Doug's article.

You'll have to fix this problem before the macro will run and prompt you for
a file name.
 

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