Excel Outbound faxing - Fax Server

  • Hello all,


    I have managed to mimic the mail merge design to an Excel document, however, I am having difficultly automatically assigning the 'To' and 'Fax' field to the fields via Captaris Rightfax. Does anyone know how I could possible tag these fields so they could possibly pull from Excel to Rightfax?


    Thank you so much!

  • Re: Excel Outbound faxing - Fax Server


    I also have this macro that was made for Word... Curious if it can be converted to Excel because it would solve the current issue.


    Thank you..


    Code
    1. Sub SplitMergeLetterToPrinter()
    2. Letters = ActiveDocument.Sections.Count
    3. counter = 1
    4. While counter < Letters
    5. ActiveDocument.PrintOut Background:=False, Range:=wdPrintFromTo, _
    6. From:="s" & Format(counter), To:="s" & Format(counter)
    7. counter = counter + 1
    8. Wend
    9. End Sub
  • Re: Excel Outbound faxing - Fax Server


    Please, if anyone has any insight regarding using Excel in order to populate outbound fax fields, much like Word's mail merge function, it'd be greatly appreciated.