Search results

Thanks for the responses... i found this code online and copy and pasted it into outlook. Its designed to search the body of an email for the word "Attached" and if it see it and there is no attachment then it should flag up a warning that there is no attachment found. It works perfectly when...

Thanks for that but unsure as to how it may help me in this instance. Searched the web high and low with no joy. Really frustrating this :banghead:

Tried changing it to the above this morning with no joy. I wonder if Outlook only sees attachments as a size in KB/MB and not how many attachments.

Code looks like this now. Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) If InStr(1, Item.Body, "attach", vbTextCompare) > 1 Then If Item.Attachments.Count = 0 Then answer = MsgBox("There's no attachment, send anyway?", vbYesNo)...

That kind of works. Still a problem though, Now no matter how many attachments i have it always prompts me as if there is no attachment. :banghead: Thanks for the reply though

Could someone please help me with the below code. I know this is a access forum but im sure the VBA code for access will be similar and the knowledge of people on here will solve this no problem. I have seen this code on another site and coded it into all the correct places on outlook but i...

I have a simple access database which up until now was working as it should. Then i made a Backup of the database Named it something different deleted certain data from the backup and when i went back into the original DB i now have #Name? where it used to calculate 2 fields. I have searched...

Thanks Bob, Will have a look into it tonight.

Hello All, My name is Ross and I am a Business Shareholder of a small but growing engineering company in central Scotland. We started around 2 years ago with only myself and a silent partner, we now have 6 members on the payroll. When it was only me here i was using Excel for day to day...

My names Ross im an Absolute beginner at access so go easy on me Sorry if ive post this in the wrong section. I have been using Excel for my business needs and feel its time to get something more usable. I like a challenge and feel that access can do everything that i want. I have sat...