Unable to publish tablein Outlook

Rajneesh Rawat

New Member
Joined
Mar 31, 2017
Messages
32
Hi All,

I am getting publish error (.Publish (True))in below code in Clinet enviornment, However it working fine on my system.

Even if i am trying to creating a HTML page manually, it is showing as "Page can't be displayed".

Can anyone suggest here what setting needs to change for fix this issue.

Code:
    'Publish the sheet to a htm file
    With zkb.PublishObjects.Add( _
         SourceType:=xlSourceRange, _
         Filename:=TempFile, _
         Sheet:=zkb.Sheets(1).Name, _
         Source:=zkb.Sheets(1).Range("A2:E5").Address, _
         HtmlType:=xlHtmlStatic)
        .Publish (True)
    End With
regards
Rajneesh
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,090,142
Messages
5,412,696
Members
403,442
Latest member
keowinvip1

This Week's Hot Topics

Top