MailMerge Faxing Excel file

[Edward Mullen]

Configuration Information:
Operating system: Windows 98
Network: --Other--

Is there anyway to Mail Merge an Excel file?

Ideally, I have a Word document with fields in it (letter and cover
page) and I want to also include, as a third page of the fax, an
Excel chart/graph.

I can do this to a single contact by ADDING a file when I go to a
single contact (using WinFax 8.03). However, when i mailmerge, i do
not get the option.

Is there a way to do what I'd like?

Thanks!

[Patti Fort [Symantec]]

On 23 Sep 1998 16:20:43 GMT, Edward Mullen <xemu...@lycosmail.com>
wrote:

>Is there anyway to Mail Merge an Excel file?
>
>Ideally, I have a Word document with fields in it (letter and cover
>page) and I want to also include, as a third page of the fax, an
>Excel chart/graph.
>
>I can do this to a single contact by ADDING a file when I go to a
>single contact (using WinFax 8.03). However, when i mailmerge, i do
>not get the option.
>
>Is there a way to do what I'd like?

Hello Edward,

You have to use an ACT/MS Word template when you are using fax mail
merge.

You can edit any ACT/MS Word template by selecting Write, Edit
document template. Select the template you want to edit and insert or
paste the spreadsheet into the template. Save the changes and use this
template for the mail merge.

I suggest you take a look at this article and send a test fax to
yourself, sometimes formatting gets changed with inserted files.

Title: 'How to Minimize Formatting Changes When Printing to WinFax'
Document ID: 1997326173532
Web URL:
http://service1.symantec.com/SUPPORT/faxprod.nsf/docid/1997326173532

Let us know if we can be of further assistance

Patti Fort [Symantec]
ACT! Technical Support
Symantec Corporation

Please continue to post your messages to the public discussion groups
as Symantec does not provide support via private email.

If you have difficulty getting a response, please read the following
article:

http://service1.symantec.com/SUPPORT/sharedtech.nsf/docid/1998527114414

For free technical support newsletters, Knowledge Base support
articles, our Online Support Genie, and FAQs, visit our ACT! support
page:

http://www.symantec.com/techsupp/act.html

[Edward Mullen]

I understand how to edit templates. What I need to do, however, is
have aprintout from Excel go after the Word template. It is not 1
chart. But a series of charts, graphs, complex calculations, and
formatting. If I Attach the file, it works perfectly.

What I need is a way to automate the fact that I want to MailMerge
Template X.ADT, and then attach file X.xls to the mass-fax blast.

Does that clarify? Thanks.

[Patti Fort [Symantec]]

On 25 Sep 1998 17:38:02 GMT, Edward Mullen <xemu...@lycosmail.com>
wrote:

>What I need is a way to automate the fact that I want to MailMerge

>Template X.ADT, and then attach file X.xls to the mass-fax blast.
>
>Does that clarify? Thanks.

Hello Edward,

Unfortunately you can not attach files during a mail merge, only when
you fax to a single contact. The entire text you want to send must be
part of the template you are using in the mail merge.

I'm sorry I could not be of more help for you today.