question about ranges, PublishObjects.Add, and Outlook emails

[marduk813]

I have a situation where I need to use multiple ranges in the PublishObjects.Add method. My range object comes out to be "A3:A15, T3:AB15". This seems to work fine by itself, but once I try to use it in the PublishObjects.Add method, it errors out with an application- or object-defined error. A simple range of "A3:A15" works fine though.

I'm trying to copy two ranges to an HTML file to then be copied to the body of an Outlook email, such as what was mentioned here:

[URL unfurl="true"]http://www.tek-tips.com/viewthread.cfm?qid=1167241[/url]

Any suggestions on possibly a better way to do this?

 

[marduk813]

As it turns out, I found a workaround. Rather than trying to copy both ranges to the HTML file, I copied them to another part of the worksheet first so that they were right next to each other, then copied that new range to the HTML file.

 

[firefytr]

Nice workaround.

-----------
Regards,
Zack Barresse