Access 2003, Outlook 2003 & PDF?

[Guest]

Okay, I am completely new to Access, but here's what I'd like to accomplish.
I'd like to send out a custom designed (HTML) email to "many" subscribers
that would also have a PDF file "attached" to the "email." (an attached PDF
is necessary) I would also like to be able to send the email out, whereas a
subscriber will not see the other email addresses/recipients on the list.

My goal is to set this up within Access, so as, eventually all I would need
to do is link the weekly PDF file I create, then push a button in Access and
out it goes.

I've already picked up some basic info here today, as well as, two links
(www.mvps.org/access & www.granite.ab.ca) and names to a few PDF programs
which I plan to research. I have also purchased Access 2003 Step-By-Step as a
primer.

Of course, I am not looking for a complete step-by-step here, I just need
some tutorial links, best books and any advice on what I should be looking
into. (The book doesn't need to be "too" basic, just easy reading and an
excellent reference.)

From what I've read here today and in brief, I believe I have to "link" the
PDF file and then do "whatever" (within Access) to call upon Outlook to email
the HTML & PDF attachment, correct? Am I at least on the right track here?

PHEW!
Thanks in advance guys.
Yvonne

 

[Arvin Meyer]

The code you'll need for the attachments is at my website:

http://www.datastrat.com/Code/OutlookEmail.txt
and
http://www.datastrat.com/Code/MultipleEmail.txt

I'd build the HTML as either Outlook stationery, or a signature. The books
and other sites you have are excellent sources.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Hi Arvin,
Thanks kindly for your response and for sharing the codes as well. I've
also browsed through your site and have picked up some of your other
offerings. Building the HTML as either Outlook stationary or a signature
sounds most logical, thanks for that tip as well.

I do however have 2 basic questions regarding the codes you've shared.
Although I have yet to advance that far, I just want to ensure I am
researching the correct program. I am not sure at the moment on how or where
the code would be used, common sense tells me, I am to use the code with
Outlook, yes? (I may be wrong.) I believe one is to initially allow for an
attachment to an email using Outlook and the other would allow sending out to
many recipients, correct? I am sure I'll eventually teach myself "how" to use
the code and all else involved with databases, mass emailing, etc... but just
figured I might be able to get a head start by posting here. I had already
planned on using pre-assembled code if I stumbled onto something that
required it, and, if I was still unable to write it myself. Your reply has
put me a step ahead which I really appreciate.

I am a graphic artist and have saved your site. Should I again come across a
client who may require your type of services, I'll be sure to pass along your
site as an option to look into. Again, thanks for your suggestion and
offering.

Yvonne

 

[Arvin Meyer]

I do however have 2 basic questions regarding the codes you've shared.
Although I have yet to advance that far, I just want to ensure I am
researching the correct program. I am not sure at the moment on how or where
the code would be used, common sense tells me, I am to use the code with
Outlook, yes?

The code would run from a button on an Access form. You'd need to set a
reference to Microsoft Outlook (and whichever version was on that machine)
In any code window you can do that from the Tools menu item.

(I may be wrong.) I believe one is to initially allow for an
attachment to an email using Outlook and the other would allow sending out to
many recipients, correct?

Correct. In the code:

With objEmail
.Attachments.Add "C:\Test.htm"
'.attachments.Add "C:\Path\to\the\next\file.txt"
End With

The first attachment line show to send an attachment. The second one which
is commented out, adds a second attachment.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access