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.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Emily" <Emily[ at ]discussions.microsoft.com> wrote in message
news:C70ACA42-13CC-4A9C-A2C7-531E6696EE91[ at ]microsoft.com...
[Quoted Text] > 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.
>
> --
> Thanks,
>
> Emily
|