Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    e-mail Merge (Access 2007)

    I have an access database which I have been using as a mail-merge data source in MS Word. The data merged includes snail-mail address data, Monthly C/f account balances, charges and payments and a closing balance. It works great as I can fit 3 to a page and it fits neatly into a window faced envelope. I now wish to merge some of the data to E-MAIL where the recipient has an e-mail address, and continue Snail-mail for those who don't. Can anyone point me to an article where I might learn how to merge-to-e-mail from my tblMailMerge table, as a part of the body of the e-mail rather than as an attachment.

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

    Re: e-mail Merge (Access 2007)

    Word has an option to send documents as attachment or not in the General tab of Tools | Options. If you clear this check box and set up a mail merge to e-mail, the text should go out as the body of the emails.

    Alternatively, you could create the e-mails in code in Access by looping through a record set and using DoCmd.SendObject.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: e-mail Merge (Access 2007)

    Thanks Hans, I'll give it a go

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: e-mail Merge (Access 2007)

    Hi Hans,

    Still having a little trouble with this.
    Financial Data is in an Access database, as is the snail mail adrress. No problem with this as I merge data to priinter.
    However, how do I mail merge to e-mail, pick up the Financial data from Access table and get it into the body of the e-mail and the e-mail address from Outlook. If I create a field in Access for e-mail address, how to I get this from Access into the 'To:' field of n e-mail.

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

    Re: e-mail Merge (Access 2007)

    If you want to send individual messages, you should put the e-mail addresses in the Access data source, otherwise the mail merge doesn't know which e-mail address belongs with which message.

    I have no experience with Office 2007, but in Word 2002 and 2003, you will be asked to specify the field that contains the e-mail address in the very last step of the Mail Merge Wizard (aka task pane), when you click "Merge to e-mail".

  6. #6
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: e-mail Merge (Access 2007)

    Thanks for quick response, will play some more.

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: e-mail Merge (Access 2007)

    Sorry to be so late to the party, but if you haven't resolved this issue, I would suggest doing the whole thing in Access. We have a client who sends out an email with a customized body and an attached Excel workbook to 600 or so people who do have email, and sends a printed copy to those who don't have an email, or can't open an Excel workbook. We do it all in Access with automation to Outlook. If you would like some sample code, I would be happy to post it.
    Wendell

  8. #8
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: e-mail Merge (Access 2007)

    Hi Wendel,
    Started reading some of my old posts, and found this one 12 months old to the day.
    Problem has still not been solved. Have even resorted to freeware third party options, but these cause HTML currency formatting problems when balance is negative.

    Would be interested in looking at some code, as issue has raised its head again with Australia Post increasing cost of postage stamps.
    Also need to attach a pdf document (same for all recipients), and have been unable to do this from word.

    Thanks in advance.

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

    Re: e-mail Merge (Access 2007)

    If you search this forum for outlook.application you will find numerous examples of automating Outlook from Access, including examples of looping through a recordset and of attaching files.

Posting Permissions

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