Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Single Quotes around email address create from a Macro in Access

Posted on 2007-11-21
13
Medium Priority
?
1,345 Views
Last Modified: 2013-11-27
Access or Outlook is placing a single quotes around email addresses I have in a macro in Access.  The problem is that people are not receiving the emails when quotes are around the email address.  How can I get rid of the quotes.

thks
Ken
0
Comment
Question by:kdr2003
  • 6
  • 4
  • 3
13 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 20329342
you can eliminate them using the vba Replace function

Replace(vString,chr(39),"")
0
 

Author Comment

by:kdr2003
ID: 20330259
Hi Capricorn1,
                        Where would I use this function when I am just placing the email addresses in the macro using send output?

Thks
Ken
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 20330578
you can convert that macro into VBA codes. using VBA codes you will have more flexibility

Tools>Macro>convert macros to visual basic

after the conversion post the converted codes here and we will see where we could insert the Replace function
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 44

Expert Comment

by:GRayL
ID: 20330938
Why is that happening in the first place?  What does the macro do?
0
 

Author Comment

by:kdr2003
ID: 20331242
Thanks Capricorn1:

Below is the code:

Option Compare Database

'------------------------------------------------------------
' OrderExpressEmailPaidTransactions
'
'------------------------------------------------------------
Function OrderExpressEmailPaidTransactions()
On Error GoTo OrderExpressEmailPaidTransactions_Err

    DoCmd.OpenForm "OrderExpress Paid Dates", acNormal, "", "", , acNormal
    DoCmd.SendObject acReport, "Order Express Paid Transactions", "SnapshotFormat(*.snp)", "samuel.ramirez@orderexpress.com.mx;tesoreria@orderexpress.com.mx;martin.martinez@orderexpress.com.mx", "Kenneth.D.Rosak@citi.com;Jesus.Guerrero@citi.com;yescenia.c.arellano@citi.com;ariadna.b.ortiz@citi.com;celina.e.evans@citi.com", "", "Order Express Paid Transactions", "", False, ""
    DoCmd.Close acForm, "AFEX Paid Dates"
    DoCmd.Quit acExit


OrderExpressEmailPaidTransactions_Exit:
    Exit Function

OrderExpressEmailPaidTransactions_Err:
    MsgBox Error$
    Resume OrderExpressEmailPaidTransactions_Exit

End Function

0
 
LVL 44

Expert Comment

by:GRayL
ID: 20331560
My point is - with that sendobject command, there should not be any single quotes around individual email addresses.

DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]

It appears there should be nothing between the commas following the [cc].  Try removing the pair of double quotes leaving just two commas.
0
 

Author Comment

by:kdr2003
ID: 20331980
GRayL:
              You get a compile error if you remove the quotes.

Ken
0
 
LVL 44

Expert Comment

by:GRayL
ID: 20332336
Are you saying a compile error if you remove the empty double quotes between the two commas?
0
 

Author Comment

by:kdr2003
ID: 20340021
Yes GrayL
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 20340073
those quotes are required for the email addresses.
your codes looks good and i don't see anything that can cause the single quote to be inserted, the single quote must be generated by Outlook (not sure though)

can you post here the generated email addresses with single quotes.
0
 

Author Comment

by:kdr2003
ID: 20340841
From: Rosak, Kenneth
Sent: Friday, November 23, 2007 4:16 AM
To: 'samuel.ramirez@orderexpress.com.mx';
'tesoreria@orderexpress.com.mx'; 'martin.martinez@orderexpress.com.mx'
Cc: 'Kenneth.D.Rosak@citi.com'; 'Jesus.Guerrero@citi.com';
'yescenia.c.arellano@citi.com'; 'ariadna.b.ortiz@citi.com';
'celina.e.evans@citi.com'
Subject: Order Express Paid Transactions Holiday

Attachments: Order Express Paid Transactions.snp
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 20358532
kdr2003,
tried to reproduce the error you are getting but i couldn't.

try posting the problem to the Outlook TA.
0
 

Accepted Solution

by:
kdr2003 earned 0 total points
ID: 20385994
I solved the problem by creating a outlook rule with recipients email addresses without quotes.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question