Use a Variable in SendObject arguments

[cbriscoe]

I would like the SendObject to use the Email address (Email_Address) from a form, when I try any iteration of Me - Me! or use brackets and call out the variable Form!FormName.TextName, it just transfers the text and does not get the form name. Is there a way to insert the variable into the following argument:

DoCmd.SendObject acReport, "Aging Skin Care Supplement", "XPSFormat(*.xps)", Me![Email_Address], "", "", "Aging Skin Care Supplement", "Attached is your Personalized Skin Care Instructions. Be sure to contact your Profiler for any questions", True, ""

Of course it is the Me![Email_Adress] that needs to change and I have honestly tried everything, I found some answers on the forum, but they required saving the object as a PDF first -- I tried tweaking it to work, but I am not sure if it is because we use XPS that it isn't work or something else entirely.

Thanks so much for you help on this.


CB

[June7]

You are correctly referencing the email variable. I am not familiar with XPS format but I think you are not correctly referencing the output format. Try:

DoCmd.SendObject acReport, "Aging Skin Care Supplement", acFormatXPS, Me![Email_Address], "", "", "Aging Skin Care Supplement", "Attached is your Personalized Skin Care Instructions. Be sure to contact your Profiler for any questions", True, ""

Review http://www.fmsinc.com/MicrosoftAcces...endObject.html

[cbriscoe]

You are just plain awesome. Thanks for your help

CB