Outlook Attachment - PDF file not attaching.

Hi All

Hope someone can help with my query.

I have an excel workbook. I am using 2 macros, one to send a worksheet in data format and 1 to send the same worksheet in PDF format via Outlook as an attachment.

When I run the macros through my own computer they work fine, but when run through a different computer the data file macro runs fine, but the email for the PDF file sends, but without the attachment.

I was wondering if someone could point me in the right direction to solving this problem.....would it be connected to anti virus?

Any help would be much appreciated.


Kindest regards

Diane

Many thanks Lokesh Kumar for your quick replay.

I can check the excel versions, but to be honest I am totally out of my depth when it comes to library and bindings..... I didn't write the macros myself.

Would be very grateful if you could explain a little.

Thanks

Just enquired about versions ........

I am using excel 2010 and the other computer is using 2007......could that be the issue?

Thanks

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi Lokesh

My apologies I posted the same code twice by mistake (now removed)

I have left the 2 codes which I using.

Sorry

Many thanks LokeshKumar for your help.

I will certainly action your recommendations. It will take a couple of days to do this, but I will get back to you with the outcome as soon as I can.

Your help is much appreciated.

Kindest regards


Diane

UPDATE

Its seems the problem was due to the different versions of Outlook/Excel.

I requested that the file and macros be run on a different machine, but only one using Office 2010 and not 2007 (within that particular depot).

The emails and attachments came through without a problem.

Thanks for the advise.

Diane