Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    multiple e-mail list for outlook express (2002)

    I have a e-mail address in a table of customers, I would like to create a report that lists the e-mail in report that I can transfer to using the tools office link, the publishe to word From Word I would then a copy and paste the results in outlook express. The format of the results are my e-mail addresses followed by a colon with no paragraph breaks. For example:

    person1@msn.com;person2@msn.com;pers...erson6@msn.com;
    person7@msn.com;person8@msn.com;pers...rson12@msn.com;

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: multiple e-mail list for outlook express (2002)

    The attachment to <post:=301,393>post 301,393</post:> contains the code for a function named Concat that you can use to concatenate the e-mail addresses into one long string. You should copy the function into a standard module.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: multiple e-mail list for outlook express (2002)

    Is there a way to do this in a simpler fashion, I am unable to follow the vba example put forward.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: multiple e-mail list for outlook express (2002)

    It's not all that difficult. Try the following steps:

    1) Open your database.
    2) Activate the Modules section of the database window.
    3) Click New.
    4) Copy and paste the code from the attachment to the post I mentioned.
    5) Switch back to Access.
    6) Activate the Reports section of the database window.
    7) Create a new report in design view.
    8) Make the detail section the correct width (about 15 cm/6" for a portrait page, 25 cm/10" for a landscape page)
    9) Create a text box in the detail section and make it as wide as the detail section.
    10) Set the Control Source of the text box to
    <code>
    =Concat("tblCustomers","strEmail",,,";")
    </code>
    where tblCustomers is the name of the customer table, and strEmail is the name of the e-mail field.

    It takes longer to type this than to actually do it!

  5. #5
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: multiple e-mail list for outlook express (2002

    Hans--I was trying to use the code from the attachment from the post [301,393]. When I try to compile it, I get errors on the following lines:
    Dim dbs As DAO.Database
    Dim rst As DAO.Recordset

    What do these mean, and how do I clear it up?

    Thanks

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: multiple e-mail list for outlook express (2002

    Hans is probably fast asleep, I think he sleeps.

    Set a reference to the Misrosoft DAO 3.6 Object Library.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: multiple e-mail list for outlook express (2002

    Pat already pointed out that you must set a reference to the Microsoft DAO 3.6 Object Library (thanks, Pat). For completeness' sake: select Tools | References... in the Visual Basic Editor to set or clear references.

Posting Permissions

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