Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    New Lounger
    Join Date
    Feb 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access e mail merge (office xp)

    Hi all, can anybody help ? I have an access database that has e mail address within it and i can create a table that lists them , what i want to do is take the e mail addresses and merge them into an email BUT i want them to go into the BCC address box . I am not an expert user (non tecky) and would appreciate a step by step if possible.
    Thanks in advance

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

    Re: Access e mail merge (office xp)

    Do you want to merge through Word, or do you want to send directly from Access? If the latter, do you want to send one mail with all recipients in the BCC box, or individual mails to each recipient?

  3. #3
    New Lounger
    Join Date
    Feb 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access e mail merge (office xp)

    I would like to do it directly from access with all the addresses goining into the BCC box please

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

    Re: Access e mail merge (office xp)

    You can do this in Visual Basic: the DoCmd.SendObject method has a BCC argument. To concatenate all e-mail addresses from a table into a single string, you can use the Concat function attached to <post#=301393>post 301393</post#>. You must copy that function into a module. The syntax for the send command would look like this (assuming you don't want to attach a database object as an attachment):
    <code>
    Dim strRecipients As String
    strRecipients = Concat("NameOfTable", "NameOfMailField")
    DoCmd.SendObject BCC:=strRecipients, Subject:="Test e-mail", _
    MessageText:="This is a test of the emergency broadcasting system." & _
    vbCrLf & vbCrLf & "Ian Lutley", EditMessage:=True
    </code>
    Replace NameOfTable and NameOfMailField with the appropriate table and field name, and edit the subject and message text as needed.

  5. #5
    New Lounger
    Join Date
    Feb 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access e mail merge (office xp)

    Thanks Hans - I will try and give it a go over the weekend

  6. #6
    New Lounger
    Join Date
    Feb 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access e mail merge (office xp)

    Hans,
    Does the concat function work in 2000 ??
    Regards Ian

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

    Re: Access e mail merge (office xp)

    It should work in Access 2000, but it uses DAO, so you must have a reference to the DAO library:
    - Activate the Visual Basic Editor.
    - Select Tools | References...
    - Locate "Microsoft DAO 3.6 Object Library".
    - Tick the corresponding check box and click OK.

  8. #8
    New Lounger
    Join Date
    Feb 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access e mail merge (office xp)

    Thanks Hans, I will try again.
    an

  9. #9
    New Lounger
    Join Date
    Feb 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access e mail merge (office xp)

    Hans,
    My girlfriend is trying this and she says she is not using DOA
    Is thier another way ??
    Ian

  10. #10
    New Lounger
    Join Date
    Feb 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access e mail merge (office xp)

    Hans,
    she also does not know how to count the number of records in a query

    Ian

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

    Re: Access e mail merge (office xp)

    See my previous reply for instructions on how to set a reference to the DAO (not DOA) library.

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

    Re: Access e mail merge (office xp)

    Does she want to count records within a query itself, or does she want to use VBA code to count records in a recordset?

  13. #13
    New Lounger
    Join Date
    Feb 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access e mail merge (office xp)

    The vba code please
    Ian

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

    Re: Access e mail merge (office xp)

    You can use DCount function: DCount("*", "NameOfTableOrQuery") returns the number of records in the specified table or query.

  15. #15
    New Lounger
    Join Date
    Feb 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access e mail merge (office xp)

    Thank You, Will give it another go
    Regards Ian

Page 1 of 2 12 LastLast

Posting Permissions

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