View Single Post
  #3  
Old September 11th 09, 04:16 PM posted to microsoft.public.outlook.program_vba
KimS
external usenet poster
 
Posts: 4
Default Mail Merge to email with attachments

Thanks for the quick response. I probably should have mentioned a couple of
other items: 1) I have MS Office 2003 and VBA version 6.5. 2) I am not well
versed in VBA, though I have developed a few macros to make life easier.

When I go to references, all I can do is either select or disselect objects.
There is no option for modification. I do have the Microsoft Office 11.0
Object Library selected.

Is there an easier way to link emails with unique files for a large emailing?

"Sue Mosher [MVP]" wrote:

It's a simple error with a simple fix: Use the Tools | References command to
add a reference to the Microsoft Outlook library and any other non-Word
library that your code might nteed.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"KimS" wrote in message
...
I found instructions for using mail merge in Word to send multiple emails
with attachments ("Mail Merge to E-mail with Attachments" by Doug
Robbins).
The macro generates an error and I have not been able to find a way around
it.
"Dim oOutlookApp As Outlook.Application" generates the following error:
Compile Error: User-defined type not defined

I don't know if and when I get around this there will be more errors or
not...

My goal is to send out 200 emails to 200 different addresses. The email
text message and subject line are the same, but each email has a unique
attachment. The attachments are all updated on a regular basis and are
sent
out via email after each update.

Any help is greatly appreciated.




Ads