Autofit Excel Report (1 Viewer)

PNEfinney · Oct 3, 2019

Hi,

New poster, new to the forum, new to access vba.

Have created a vba module that takes all named reports assigned to any one of 150 and emails a spreadsheet listing all the reports to the recipient.

The issue is that when it arrives, it’s all scrunched up and I can’t seem to see if there’s a way I can specify the report to be auto wrapped by the recipient. Any ideas?

arnelgp · Oct 3, 2019

are you sending through SendObject?
do you have a report for the list, sent as excel file?

PNEfinney · Oct 4, 2019

arnelgp said:
are you sending through SendObject?
do you have a report for the list, sent as excel file?

Hiya,

Yes sending through sendobject. There’s two parts to the module, the first that searches a linked table for the recipient and compiles a query of name and report name for that person and then then two blank fields for the recipient to complete and return. The second part is the cmd the send as an xlsx file.

PNEfinney · Oct 14, 2019

Any ideas anyone?

arnelgp · Oct 14, 2019

you need to make manual adjustment to the report in design view.

PNEfinney · Oct 15, 2019

Thanks for replying, but are you able to do that when the VBA is creating the report? I will never get the design view cos its all done by the VBA.

As there 185 Recipients and reports being sent, I thought it best to wrap the whole exercise in one loop.

Autofit Excel Report (1 Viewer)

PNEfinney

New member

arnelgp

..forever waiting... waiting for jellybean!

PNEfinney

New member

PNEfinney

New member

arnelgp

..forever waiting... waiting for jellybean!

PNEfinney

New member

Similar threads

Users who are viewing this thread