Thanks JerryKlmns.
Although I was hoping to continue using simple MAPI rather than change to creating outlook objects but I don't think i have a choice.
Rupert
Hi,
I was having simliar random issue on whether excel closed on not but not since finally getting the order right as below. The only difference I see from previous suggestions is to set the workbook saved as true.
xlBook.SaveAs ("C:\working\file_" & Format(Date, "mmdd") & ".xls")...
Using MAPISendMail32 through VBA to send emails from access.
For the message flags parameter you get a choice of:
MAPI_RECEIPT_REQUESTED
MAPI_SENT
MAPI_UNREAD
Using 'MAPI_RECEIPT_REQUESTED' I get a email back when the message is read, but I want to get one for delivery instead.
I've searched...
Yeah your right, but if they ain't got internet access they can't get the full email.
Think we're going to compromise, still in HTML format but not embed the font(no not big file), but provide an absolute URL to the font so if they have internet access they read the email in the corporate font...
Prob. Anyone know how to reference an embedded font without scripting ? (as most people have scripting disabled to avoid harmful scripts being run)
Background. I have an editable font and have used Microsofts WEFT utility to create the .eot file (as detailed in the great article...
Hi,
I'm converting numerous version 2 backend databases to XP.
They have lots of tables, but only a couple of forms and a single module.
I have been trying to use ConvertAccessProject as detailed in Technet and it works apart from the module which does not get copied across to the new...
Hi Ken
Thanks. I've been through the articles today and found a few refernces to persistent connections. Having made each of the front ends open up a connection to the back end when the first form loads, further processing (opening a datasheet, linked table manager) takes only a few seconds...
Any ideas welcomed !
Having converted from Access version 2 to 97 and finally XP its really annoying to find its much slower in a multi-user environment.
I've read through loads of tips like ADO/DAO, Name autocorrect etc... which all help but how come its much slower at the 'core' e.g tables -...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.