View Single Post
  #2  
Old November 9th 07, 07:01 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Send invitation project



You might look at the one thread previous to this one: "Can I get Outlook to
prompt when dates in Excel files become current". That gives you a starting
point. Instead of creating AppointmentItems you want to create MailItems, of
course.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Synchronize Color Categories & Ensure that Every Item Gets Categorized:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Thu, 8 Nov 2007 00:40:01 -0800 schrieb LEE:

I got an excel file with three columns: serialno, name, email. How can I

send
individual email to everyone (i.e. only one address in To on the Excel
file? Can I import the excel file to a new group? Or any other faster

method?
The message has the same pdf and one unique pdf named as the serial no. on
the excel file. Also, it displays the corresponding name on the excel

file.
How to get this task done in Outlook? Some programming in Outlook is
accepted. The message is like:

Dear XXX, (where XXX is the name on the excel)

We are writing to invite you.

attachments: invitation.pdf; serialno.pdf (where serialno is the serialno

on
the excel. e.g. 00001.pdf)

Many thanks

Ads