Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1005
  • Last Modified:

attach a PDF document to an e-mail message

What is the VBA code to create and attach a PDF document to an e-mail message.  I want to prompt for an email address (or check for an existing one with a record) first.
0
cagilbert
Asked:
cagilbert
  • 2
1 Solution
 
tbsgadiCommented:
Hi cagilbert,

Check out http://www.jephens.com/howtoemail.asp
Uncomment the line for the pdf attachment

Good Luck!

Gary
0
 
cagilbertAuthor Commented:
But th 'Note' below that is part of the document referred to makes me think that I'm going to get the security prompt for each email.  Is that the case?  If so, it won't work.

Anyone know how to use the newer Office 2007 Add-in to create PDF's?  It seems like a different process.

"NOTE: The Outlook Security Patch (it comes with Office 2000 SR-2, OfficeXP or as a seperate "security" download) makes this exercise just this side of useless. Since virus writers use these same techniques to send e-mail without you knowing, Microsoft instead pops up a dialog box for 3-5 seconds PER ADDRESS so the virus writer can't take advantage of you. Of course, YOU can't take advantage of this power any longer, since MS thinks you're unable to protect yourself. *sigh* Perhaps one of these days I will write an article explaining how to do this using a freeware mail component..."
0
 
tbsgadiCommented:
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now