E-Mail Merge Coding (AC 2007)

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote

Thanks Hans, dosn’t hurt to ask.

Merry Christmas

Reply | Quote