PC Review


Reply
Thread Tools Rate Thread

Address Email

 
 
StephanieH
Guest
Posts: n/a
 
      22nd Jul 2008
I have the following code set up to send an email. I want it to automatically
enter a comma after the name in [BusAutRepresentative] but can't quite figure
it out. I've tried inserting & "," after the field name and before the
separating comma. It doesn't debug but it doesn't insert the comma either.
What am I doing wrong?

Private Sub Command48_Click()
Dim strDocName As String
Dim strWhere As String
strDocName = "Requests"
strWhere = "[ID]=" & Me!txt_ID
DoCmd.OpenReport strDocName, acPreview, , strWhere
DoCmd.SendObject acSendReport, "Requests", acFormatRTF,
[BusAutRepresentative], , , _
"Request: " & [txt_ID] & " " & [Topic/Project Name]

End Sub
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using security group email address as default reply email address =?Utf-8?B?dHJhY3lseW5uNDEz?= Microsoft Outlook Discussion 0 23rd Oct 2007 10:00 PM
Send Email from Access changing email address in From to be different than sending address tomlebold@msn.com Microsoft Access 0 7th Dec 2006 08:44 PM
Replacing sender email address by distribution list email address ? Xavier Microsoft Outlook Discussion 2 3rd May 2006 12:33 PM
Set which local email account can send mail to contacts in address book. (associating an email address with a contact) Scott Streit Microsoft Outlook 3 27th Jan 2006 02:57 PM
Internet email reply address showing internal email address =?Utf-8?B?S0xZb3VuZw==?= Microsoft Outlook Discussion 3 25th Feb 2004 01:34 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:09 AM.