Results 1 to 3 of 3
  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 Coding (AC 2007)

    As part of code which sends an E-Mail from Access, I have the following:-

    MyMail.Body = Month$ & " Dues Notice for " & MailList("Initial") & " " & MailList("SurName") _
    & vbNewLine & vbNewLine _
    & "Dues Carried Forward " & Format(MailList("CFwd"), "$#,##0.00 ;($#,##0.00)") & vbNewLine _
    & "This Month's Dues " & Format(MailList("Dues"), "$#,##0.00 ;($#,##0.00)") & vbNewLine _
    & "Owed /(In Credit) " & Format(MailList("Owed"), "$#,##0.00 ;($#,##0.00)")

    Can anyone advise me how I might align these amounts to the right.

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

    Re: E-Mail Merge Coding (AC 2007)

    There's no support for right-aligning text. Anyway, you have no control over how the recipient views the e-mail...

  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 Coding (AC 2007)

    Thanks Hans, dosn't hurt to ask.

    Merry Christmas

Posting Permissions

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