Automating emails

[Guest]

I am a used equipment reseller/locator. I call on companies, find out what
equipment they need then email the requests to a list of equipment brokers
that may have the items.

The broker list is currently in Access 2002 and I'm using XP with Office 02.
I want each mail to appear individualized for that particular broker and I
don't want them seeing the balance of my contact list.

I'd like to somehow input one message such as "customer has an urgent need
for a high-speed shear for a cut to length line. Do you have any nice HS
shears?". Then with the push of a single button (or two or three), send mails
off to all the brokers. If someone can tell me where to start, I can get the
broker data into any list (group) that will facilitate this effort (.mdb,
..xls, .wab, etc.).

Where do I start? Is there any premade progs, macros or code that will do
what I'm seeking?

 

[Sue Mosher [MVP-Outlook]]

This sounds like basic Outlook automation. You might want to start at
http://www.outlookcode.com/d/vb.htm for basics.

FYI, there is a newsgroup specifically for general Outlook programming
issues "down the hall" at microsoft.public.outlook.program_vba or, via web
interface, at
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba

If you don't want to write code, you can also accomplish something similar
with a mail merge to Word.

 

[Guest]

Thanks Sue,

In the past I would have jumped in and learned what I needed to accomplish
this. I do some elementry programming in Access. However, since I don't
expect to do much of this, the learning curve appears daunting. It's hard to
imagine that I'm requesting something so unique I need to recreat the wheel.
Isn't there some code existing out there I can get my hands on to copy and
paste? Are you suggesting I should "knock on the door down the hall" and
repost there? (I will anyway).

Bill

 

[Sue Mosher [MVP-Outlook]]

I know of no code sample that will do exactly what you describe with your
data without modifications. Therefore, you're going to have to learn how to
put the pieces together. If you have questions about the specific pieces,
"down the hall" is the place to ask about them.

As I said, if you don't want to code, use a mail merge.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers