Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Send invitation project (http://www.outlookbanter.com/outlook-vba/60780-send-invitation-project.html)

lee November 8th 07 09:40 AM

Send invitation project
 
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

Michael Bauer [MVP - Outlook] November 9th 07 08:01 AM

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



All times are GMT +1. The time now is 09:14 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com