Search results

  1. D

    Access 2003 Email as PDF

    I've successfully implemented CDO emailing. However, is there a way to create a snapshot PDF of the form? I'd like to email that in the attachment feature I have no uses for making reports in my database so Stephen Lebans code doesn't seem useful to me.
  2. D

    Bypassing Access warning messages

    Found my smtp server address to avoid the "The transport failed to connect to the server" error. The database successfully works on my computer, however, many other computers on the network can't open it as it pops up with a Missing CDO 1.21 Library reference error. How is this possible when...
  3. D

    Question Automated reminder sent to Outlook

    Firstly, how do you invite another person to the Outlook appointment using this code? or.. set the appointment for someone else on the network Also, Is there a way for Outlook to check back to the Access database for a boolean to be true or not and cancel the appointment based on that?
  4. D

    Question Automated reminder sent to Outlook

    Is there a way to call out the current date when the module is being executed? Something that can return the day, month, year of the currently ie. 01 17 2010
  5. D

    Sending Hyperlinks to Email

    Sorry I wasn't being clear enough http://www... works fine actually, BUT I'm not hyperlinking webaddresses. I'm trying to send hyperlinks for local/network drives ie. C:\TempStore\accessDatabase.mdb ...etc... These don't automatically show up as hyperlinked in Outlook since Access's auto...
  6. D

    Bypassing Access warning messages

    I tried using your example and removed all the recordset references since I won't be using them. I'm drawing email strings directly from the Forms. However, i'm getting a run time error "The "SendingUsing" configuration value is invalid" I have referenced Microsoft CDO 1.21 Library in the...
  7. D

    Question Mass Email with Access - How to get around the Security

    I've implemented this method before but decided to not use it due to two reasons. 1. I would have to insert a macro code on every user computer in the company and change their macro security settings 2. It wasn't complete 100% successful. Sometimes Outlook would simply forget I had allowed...
  8. D

    Access 2003 Email as PDF

    I'm trying to work through Stephen Lebans code for the actual PDF creation process, but it's too heavily tied in with creating PDF from a report. Anyone have experience with Lebans code and know how to actually create a PDF straight off the opened Form?
  9. D

    Sending Hyperlinks to Email

    I understand that Outlook divides its emails into three types: HTML, rich text and plain text. I'm guessing only the HTML type will support hyperlink hotlinking. I'm having Access 03 send out emails through Outlook, but how would I go about including hyperlinks? Everything should be a string...
  10. D

    Using Access to send email

    Wow what's going on with the whole iCfg.Fields section??? Why is it linking a bunch of microsoft links that are broken?
  11. D

    Calling Table Field using another Field variable

    That is awesome! thanks mate
  12. D

    Access 2003 Email as PDF

    Is there a way to use the auto email feature in Access 03 to email the form as a PDF? I read this here pcreview.co.uk/forums/thread-3539493.php Seems that only Office 07 has the download to allow for Save As PDF feature I'm trying to use this command but it doesn't recognize object type...
  13. D

    Using Access to send email

    Nvm the installation since I it's already in the References for Access 03 But i'm still getting a popup during the run saying "User-defined type is not defined" after I added both the Microsoft CDO 1.2.1 library and the Microsoft CDO Library for Windows 2000 Library...
  14. D

    Calling Table Field using another Field variable

    I have a mailing list table set up which displays a list of ID First Name Last Name Email Address I also created a form that has a drop down menu where you can select from employees by First Name. This drop down selection is then assigned to the variable ContactName. However, can I...
  15. D

    Using Access to send email

    I see the download for CDO 1.2.1 from Microsoft However, do I need to install CDO on every computer that will be using this Access database? This could be a problem if I need to install CDO on every computer in the company..
  16. D

    Transfer results from queries to auto-email

    Is there a way to run this email reminder upon a new form creation via the Access's "Record" buttons on the bottom of the window... rather than being constrained to pressing a button on the form?
  17. D

    Using Access to send email

    I have incorporated a script that uses the SendObject function of Access which works. But each time it sends emails, there will be a security pop up box from Windows asking you if it is okay to send the email through outlook. I haven't found any way to disable this popup message indefinitely.
Back
Top Bottom