+ Reply to Thread
Results 1 to 3 of 3

Automate email send thru ms access 2010

  1. #1
    Registered User
    Join Date
    10-19-2009
    Location
    singapore
    MS-Off Ver
    2010,2013
    Posts
    45

    Automate email send thru ms access 2010

    Hi,

    my code runs well, after when i added in my body message. An error occure, it show 'RUN-TIME erro 438'.

    When i debug it, it was pointed to this the code below.

    I'm suspecting is because of the '" & .cmb_Hname.Column(4) & "' in my body message. But i would need '" & .cmb_Hname.Column(4) & "' to display in the body message and send out. How can I concatenate the whole line and send out? any advise please?

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,125

    Re: Automate email send thru ms access 2010

    remove the period in front
    .cmb_Hname.Column(4)

  3. #3
    Registered User
    Join Date
    10-19-2009
    Location
    singapore
    MS-Off Ver
    2010,2013
    Posts
    45

    Re: Automate email send thru ms access 2010

    Thanks buddy, really works. Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA code to send email to the people whose email address is in the Access table
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-30-2014, 05:11 AM
  2. Workflow with signatures (if cell=x then send email, if signed then send email)
    By Kate2811 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2014, 05:37 AM
  3. Send Email from Access using Outlook,
    By masond3 in forum Access Tables & Databases
    Replies: 1
    Last Post: 12-18-2013, 09:19 AM
  4. Disabling or interrupting "send email attachment" in excel 2010
    By andrewgarcia86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2013, 02:14 PM
  5. [SOLVED] Trying to "automate" inserting record numbers in Access 2010 query
    By alcharbonneau in forum Access Tables & Databases
    Replies: 7
    Last Post: 05-18-2012, 01:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1