Results 1 to 4 of 4
  1. #1
    rgrwatson85 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    9

    Emailing Personalized Report

    I have a macro setup so that I can send an email of an invoice report to a customer. I want to be able to personalize the email a bit and add their name into the Message Text field of the EMailDatabaseObject. I want it to say "Dear Bob, Thanks for your order! Here is a copy of your invoice." Of course Bob would could be a different name depending on which invoice report I have open at the time.

    The report is based a query called "Search Invoices" and the field name I am interested in is called [FirstName] if that helps at all.

    I have tried doing something like Dear [FirstName], ... and that just sends the email just like you are reading it now. Anyone have any ideas?

  2. #2
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    Use a text field for the greeting line, in it put

    = "Dear " & [FirstName] & ", "

  3. #3
    rgrwatson85 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    9
    Ok it worked. Thanks so much for you quick reply!

  4. #4
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    No worries, glad i could help... mark it as solved if you could.. Nevermind, you already did. LOL

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Emailing example
    By pkstormy in forum Code Repository
    Replies: 4
    Last Post: 01-31-2014, 04:22 PM
  2. Emailing Report with Attachments
    By Rookie in forum Reports
    Replies: 1
    Last Post: 08-19-2011, 06:52 PM
  3. Pop-up when emailing from Access
    By tgavin in forum Access
    Replies: 5
    Last Post: 05-02-2011, 10:56 AM
  4. Emailing a report
    By prv in forum Access
    Replies: 1
    Last Post: 12-20-2010, 04:03 PM
  5. Emailing report at the Email content
    By ylivne in forum Reports
    Replies: 0
    Last Post: 07-07-2009, 05:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums