Mail Merge and Send Fax via Email

Hi all,

I am trying to create a macro to automate sending fax requests related to data on a report, and have found the following code online which I tried to modify to meet my need. However, it is not working. It opens the Word template but gives Run-time error'438' Object doesn't support this property or method.

This is my first attempt at Mail Merge, in general, so I am practically clueless at what I am doing and will appreciate it if someone could help me, please.

Here is the code:

Please Login or Register  to view this content.

Thank you,
Gos-C

instead of:

Please Login or Register  to view this content.

try:

Please Login or Register  to view this content.

Wonderful! Big improvement. Thank you very much for spotting that and pointing it out, JoeFoot. However, it still gave the same error message, "Object doesn't support this property or method."

It fails here:

[CODE][/With .DataSource
.FirstRecord = r - 1
.LastRecord = r - 1
.ActiveRecord = r - 1
End WithCODE]

It looks like it's the code to have Outlook send all the documents (faxes) as an attachment that is not correct/needed. Can some help me, please?

Thank you,
Gos-C

remove this:

Please Login or Register  to view this content.