MailMerge Questions

[joe31709]

Okay I need to do a mailmerge into word for reports so that they can be saved and faxed if need.

first question is, Do I need to create a word document?
2. Do i really need a report created if its going to be sent to word?
3. what kind of code would I need?

anything will help.

 

[andrew93]

Hi Joe

When you say 'mail merge' are you referring to the mail merge that you do from Excel into Word? Or are you referring to a report from Access? (given you had this in the Report form).

It would help if you provided some information on where the data is stored and also what you are trying to achieve.

Andrew

 

[joe31709]

The data is stored in a table. I had a report that worked fine, but the report can not be faxed. that is why I was trying to output it into word. When you go from report to rich text you lose alot of spaces and lines with the report. That is why I was trying to do just a mail merge into word where I could save the file to a document and then fax it.

Thanks for your help.

Joe

 

[Ricky21]

I usually page dump into paint, then cut the area I want then copy from paint in to excel/word. This is the only way i've found to keep the page setup looking the same

Cheers

 

[TravisJRyan]

What about dumping the data to an excel sheet that is linked to a word document. . create code within the excel sheet to hide the entire sheet while updating. . .after update send it to word and close. . .kind of a pain but could work

 

[Rich]

The data is stored in a table. I had a report that worked fine, but the report can not be faxed.
Joe

Why not ??

 

[joe31709]

Well Rich , I dont have a clue on that. Can you fax a report from Access without printing it out?

 

[DanG]

If your computer is hooked up to a phone line and you have a fax program then your fax program/modem will show up as "Printer" when you go to print.
Or an online faxing solution (like E-Fax) MAY work though I've never tried.

 

[ScottGem]

The data is stored in a table. I had a report that worked fine, but the report can not be faxed.
Joe

http://support.microsoft.com/kb/q145787/
http://support.microsoft.com/default.aspx?scid=kb;en-us;231797

One of those two should solve your problem.